Count Days Since Ticket Opened

Bessie Koch

Hello,

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")

Paul Newcome

That is because you are not specifying what should happen when the IF statement is not true (complete is checked). If you do not specify that, it defaults to a blank output. Since there IF statement is not outputting an error, the IFERROR is not going to output the "Complete". Try this instead:

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

Paul Newcome

That is because you are not specifying what should happen when the IF statement is not true (complete is checked). If you do not specify that, it defaults to a blank output. Since there IF statement is not outputting an error, the IFERROR is not going to output the "Complete". Try this instead:

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

Bessie Koch

Perfect! Thank you!

Paul Newcome

Happy to help. 👍️