Progress bar date formula

1

I have a table with a start and end date. I have added a column as a progress bar and am trying to include a formula which represents the progress relative to today’s date, as a percentage. The formula that I’m trying to apply is…
Progress Percentage=( Current Date −Start Date / End Date−Start Date )×100

In Coda syntax, I’ve used: (Today()-Seasons.Start/Seasons.End-Seasons.Start)*100

This accurately shows no progress for items where the start date is a future date. For all entries where the start date is in the past and the end date is in the future, it’s showing a full bar with “value is currently greater than max”.

I’m guessing the issue is with my syntax but I can’t seem to find the solution…

2

I believe I figured this out. Seems that I have to do additional groupings.
((Today()-Start)/(End-Start))*100

3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.