Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Due Date is Past Due - Checkbox
I'm trying to write a formula that will "check" the checkbox if the Adj End Date is Past Due and the % complete is not 100%)
I started with just the Adj End Date portion and have not added the percent complete to the formula.
This isn't working...
=(IF(TODAY() > [Adj End Date]5,TRUE,FALSE)
I then want to do conditional formatting on it.