Request Tracker Form
Options
Answers
-
I was able to get it working. I did shift the formula around to show a negative number if it was overdue. The final version I used was
=IF([Date Need By]@row = [Estimated Completion Date]@row, "On Time", [Date Assigned]@row - [Estimated Completion Date]@row)
Thanks again for the help!
-
@Hans Millican Excellent!
Glad we got it working!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!