Count Days Since Ticket Opened

Bessie Koch
Bessie Koch ✭✭
edited 05/06/22 in Formulas and Functions


Needing to calculate number of days since line item appeared when Date Submitted column is "Auto-Number/System Generated Column Created (Date)" -- and then display "Closed" when Checkbox is checked in Complete column. Can't get the "Complete" to appear -- just goes blank.

=IFERROR(IF(Complete@row = 0, TODAY() - [Date Submitted]@row), "Complete")


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!