Allowed Values depending on Value in another column

Christian Contzen

Dear Smart Sheet Users,

 

as a newbie, I'm not familiar handling depending possible values in Smartsheet.

 

We want to approve a deployment process. 

If a user chooses value 1 in column A during data entry then there should only be a sublist of possible users to send the approval request in column B - if a user chooses value 2 then the whole list should be available.

 

Background - we want to approve deployments in Salesforce. When the deployment goes to the prod environment then only top management should be available as an approver.  

Regards,

 

Christian

Shaine Greenwood

Hi Christian,

Try building two approval request rules for this.

• If cell changes to value 1, send an approval request to User A, User B, User C
• If cell changes to value 2, send an approval request to contact column in sheet or all shared users, etc (the larger group that need it)

More on approval requests in the help center: https://help.smartsheet.com/articles/2476591-working-with-approval-requests