Help fixing this formula

Note:

If the pre-closing draw date submitted to TIGR has a number, then return ‘’TIGR’’ if not return blank.

If the pre-closing draw date submitted to QAQC has a number, then return ‘’QAQC’’ if not return blank.

If the pre-closing draw date submitted to strike Team has a number, then return ‘’Strike’’ if not return blank.

If the pre-closing draw date submitted to TIGR & pre-closing draw date submitted to QAQC & pre-closing draw date submitted to strike Team has a number, then return ‘’All Completed’’

If the pre-closing draw date submitted to TIGR has a text, then return ''N/A'',

If the pre-closing draw date submitted to Strike Team has a text, then return ''N/A'',

 If the pre-closing draw date submitted to QAQC has a text, then return ''N/A''

 

=IF(ISNUMBER([DATE Pre-Closing Draw In TIGR]@row), "TIGR", IF(ISNUMBER([DATE Pre-Closing Draw Submitted to QAQC]@row), "QAQC", IF(ISNUMBER([Pre-Closing Draw DATE Submitted to Strike Team]@row), "Strike", IF(AND(ISNUMBER([DATE Pre-Closing Draw In TIGR]@row), ISNUMBER([DATE Pre-Closing Draw Submitted to QAQC]@row), ISNUMBER([Pre-Closing Draw DATE Submitted to Strike Team]@row)),''All Completed'', '' '', IF(OR(ISTEXT([DATE Pre-Closing Draw In TIGR]@row,[DATE Pre-Closing Draw Submitted to QAQC]@row,[Pre-Closing Draw DATE Submitted to Strike Team]@row,''N/A'')))))))




Thank you for your help!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!