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?

Tags:

Best Answer

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!