July 9, 2022
Hi Mynda, Thank you SO much for your tutorial video, I just found it and it is very helpful!
I'm taking on the task of creating my own dashboard for our projects and I'm having a bit of trouble with computing the Days Completed.
I'm trying to automatically calculate this column and if I use this formula in the Days Completed column, it changes the Progress percentage to well over 100% as time goes on. =TODAY()-[@[Start Date]]
So I thought I could try this formula (saw in the video comments) but I keep getting errors. =IF(AND(TODAY()>[@[Start Date]],TODAY()<=[@[End Date]]),(TODAY()-)-1,0)
Start date and Duration columns are hard coded. End Date formula is =WORKDAY.INTL([@[Start Date]]-1,[@Duration],1)
Do you see anything here that is off in the formulas?
Thank you so much for any assistance you can provide!
July 16, 2010