IF Percentage Complete = 100% return Date

BobLonely
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..?

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!