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.
Smartsheet formulas with multiple columns
We're using Smartsheet for some change management, and I'm new to both Smartsheet and spreadsheet formulas.
What I’d like to do is have a formula looks at a column that indicates the type of change (Major, Minor, Emergency, etc.) and then looks at a number of check boxes and adds an approval in a separate column.
So, for instance, if it’s an emergency change, then only one approval is necessary. There are 6 people on the CAB, so I’d want it setup so if the change type is emergency, then as long as at least one box is checked, the change is approved. If it’s a Major change, then 3 or more check boxes would need to be checked.
If I'm thinking correctly, it would work like this: change type column determines number of check boxes necessary, a formula counts the number of boxes checked (0-6) and then determines whether a sufficient number of boxes have been checked to change a separate column to "approved."