Formulas

RotorYacht
edited 12/09/19 in Formulas and Functions

I'm Trying to add a function to the following formula in which adds "should the cell to the right of this formula show anything else except completed then the formula will display BEHIND

 

 

=IF(AND(TODAY() + 1 >= [Completion Due Date]29, [Days to Completion]29 < 100), "BEHIND", "")

IMG_3298.JPG

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!