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)




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!