Calculating elapsed time in percentage #UNPARSEABLE
I wrote the following formula to get the percentage according to the chart based on today's date, but it didn't work.
=IF(OR(ISBLANK([Start date]@row); ISBLANK([End date]@row); ISBLANK(TODAY())); "";IF(TODAY() < [Start date]@row; "Not Yet";IF(TODAY() > [End date]@row; "100%";TEXT((TODAY() - [Start date]@row + 1) / ([End date]@row - [Start date]@row + 1); "0%"))))
It is worth noting that I wrote the formula in Excel and it works fine for me.
But I don't have enough experience to do this on smartsheet
Help Article Resources
Check out the Formula Handbook template!