Count Days Since Ticket Opened
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")
Best Answer
-
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")
Answers
-
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")
-
Perfect! Thank you!
Help Article Resources
Categories
Check out the Formula Handbook template!