Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Formula to Ignore a N/A if selected from a dropdown, and not break the rest of the formula

Options

I need to add another scenario to one of y formulas,

If one of the departments does not have to approve a certain type of change, they will choose N/A from the drop-down. So I will need the Approval Status column to IGNORE the N/A in that row. So if only 3 people needed to approve it choosing then the non approvers choose N/A and the Approval Status will still show Approved.

Thanks for the help

Comments

This discussion has been closed.