Function assistance
I have a sheet that has a date column (Sent for Customer Signature Date) and a checkbox column. I am using this formula "=IF([Sent for Countersignature]@row, "0", TODAY() - [Sent for Signature Date]@row)" (this is a column formula) to calculate how many days we are waiting for the customer signature to come back. When I check off the Sent for Countersignature box it changes the field that would calculate the date to 0, however i would like this to display "Completed" is there a way to adapt my current formula to do this?
Best Answer
-
I would modify it this way... This will check to see if it's completed and mark it as completed, and if not it will calculate the number of days.
=IF([Sent for Countersignature]@row = 1, "Completed", TODAY() - [Sent for Signature Date]@row, )
Answers
-
I would modify it this way... This will check to see if it's completed and mark it as completed, and if not it will calculate the number of days.
=IF([Sent for Countersignature]@row = 1, "Completed", TODAY() - [Sent for Signature Date]@row, )
-
Perfect thank you
-
You're welcome, glad I could be of assistance.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!