IF Percentage Complete = 100% return Date

BobLonely ✭✭✭
edited 12/09/19 in Formulas and Functions

This seemed simple to me before I started.. but this has me foxed..! two columns:


% Complete [Text/Number field]

Date Complete [Date field]


What I intended is for the Date Complete cell to automatically complete with TODAY() when the user updates the "% Complete" cell is set as 100%


..what I have so far is =IF([% Complete]17 < 100, 0, TODAY())

..and I have tried =IF([% Complete]17 = 100, TODAY())


Frustratingly, I can get TODAY() to return the Date when the "% Complete" isnt 100%.. but not when it's 100%


...any ideas..?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!