Calculate days past due based on end date

I want to populate a column labeled "Days Overdue". I want to look at my column "% Complete" if "% Complete" is not equal to 100%, then get TODAY() date - "End DATE" and populate the value into "Days Overdue" column, else 0.

 

In excel I can accomplish this with the following IF statement. =IF(% Complete<>100%,TODAY()-END DATE,0)

 

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!