Nested If statemens

JackieKim
JackieKim โœญโœญ
edited 08/31/22 in Formulas and Functions

I've read various posts on the forum and have been able to fix a few of my issues but I can't seem to get past this one.

To show the stage of a project is in a workflow, I am using various IF(AND(NOT(ISBLANK, meaning that stage has been completed. So, if the Outreach stage is complete, it will not be blank, etc. In my AND formula I need to evaluate whether a client has hardware and if they do, then if the hardware has been delivered. This statement was working.

=IF(AND(NOT(ISBLANK([Scope Doc Complete]@row)), NOT(ISBLANK([CSS Outreach]@row)), NOT(ISBLANK([CSS Trans Meeting]@row)), NOT(ISBLANK([Time Implementer Assigned]@row)), NOT(ISBLANK([Configuration Complete]@row)), NOT(ISBLANK([Client Trained]@row))), IF(AND(NOT(ISBLANK([TS Hardware]@row)), NOT(ISBLANK([Hardware Received]@row))), "Awaiting Migration", "Test"))

However, the last statement is to evaluate if the migration stage is complete. To determine this, the pay date must be earlier than today and

=IF(AND(NOT(ISBLANK([Scope Doc Complete]@row)), NOT(ISBLANK([CSS Outreach]@row)), NOT(ISBLANK([CSS Trans Meeting]@row)), NOT(ISBLANK([Time Implementer Assigned]@row)), NOT(ISBLANK([Configuration Complete]@row)), NOT(ISBLANK([Client Trained]@row))), IF(AND(NOT(ISBLANK([TS Hardware]@row)), NOT(ISBLANK([Hardware Received]@row)))), NOT(ISBLANK([Migration Complete]@row)), "Extract", "Test")

Please help.

I really thought I could just start with evaluating just the 'migration complete' field but it appears the most complex statement has to be evaluated first. Is there a book or guide for formulas?

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!