Formula help please


Hi community - I am using this formula in the 'Planned progress' column of my projects:

But it returns more than 100% when the date is past todays date (see example below). So I need to add to the formula - if today's date is after the planned end date, the planned progress should always be 100% (and never more than 100%).

I'm new to Smartsheets and i'm not sure how to achieve this. Any help would be appreciated - thankyou



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!