Formula Help

Hello, I have a formula to determine the days between two cells:

=IF(OR([Status]@row = "CLOSED", ISDATE([Closure Date]@row) = 1), [Closure Date]@row - [Date Initiated]@row, TODAY() - [Date Initiated]@row)

However, I need to add in to return "N/A" to the days open if the value within Date Initiated is N/A. I have a similar formula working in Excel which if I could replicate would be excellent.

=IFERROR(IF(OR(ISNUMBER(SEARCH("review",N2)),ISBLANK(N2),ISNUMBER(SEARCH("TBD",N2))), DAYS(TODAY(),[@[Date Initiated]]),[@[Closure Date]]-[@[Date Initiated]]),"N/A")

Essentially the goal is to calculate how long a document has been opened, and once closed will appropriately just take the difference between open and closed columns. Adding in that if the document was not needed (indicated by N/A), then the output for days open would be N/A. If needed I can post a simple version of what this looks like from Excel currently.

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!