Tracking Contact Approvals in Hierarchy Level using Helper Column


Hello Smartsheet Community,

I'm creating a Smartsheet Automation to send out approvals (starting with level 1). I'm making this helper column (L1 - Status of Approvals) to determine if all the listed contacts have given approval in the contact approval columns before moving onto level 2.

As you can see in the screenshot below, in this scenario, Contact 3 doesn't have a contact, so only Contact 1 and Contact 2 should be considered when tracking approvals. However, I should be able to consider Contact 3 should that contact be added.

Please let me know if there would be some formula to make this helper column function. Thanks for your time!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!