Calculate days past due based on end date

04/16/19 Edited 12/09/19

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

  • Mike WildayMike 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. 

Sign In or Register to comment.