Allowed Values depending on Value in another column
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
Comments
-
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
Help Article Resources
Categories
Check out the Formula Handbook template!