Calculate days past due based on end date

Jon Lingerfelt

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)

 

Mike Wilday

Try this version.

=IF[% Complete]@row&lt;>1, Today()-[End Date]@row, 0)

Smartsheets references percentages as decimals of a whole number. So when you reference them in a formula use .5, to reference 50%. etc. etc.