Change Cell Value Automation/Workflow

Yes, with single select you just have 6 options.

In the workflow creation screen, click the plus sign above your first Condition block and select "Add a condition path". You can keep adding condition paths at this level of the workflow. Like formulas, Smartsheet automation works left to right, so it goes from one condition path to the next until it finds one that's true, and executes the Action below it. It does not then look at any more condition paths.

All comments

You can make one Automation with distinct condition paths for each Sector of work choice. However, if your users can select multiple entries for Sector of Work, you would need a condition path for each combination of values. That would add up to 63 condition paths to cover every combination of choices in order to set the Tag field correctly.

It's way easier to just make six automations.

Just make sure you turn this option OFF in the Change cell value Action in each automation.

Thanks, @Jeff Reisman

... What if the option is single select? Then the options would be less ( i think!)

Can I make an automation like this below for all 6 options together? I feel like I'm doing something wrong with otherwise as it doesn't allow me to add another condition.

(In reality, this is a two prong-problem where the other set I have like 60 tags to update to another row)

Screen Shot 2022-04-27 at 1.06.47 PM.png

Yes, with single select you just have 6 options.

Ah! So simple! Thank you!!

Hi @Jeff Reisman or others that can help,

I finally got had time to starting to build these out, and I'm getting invalid work flow on my tests as its saying it's circular. I don't really understand where the issue is ... Perhaps these screenshots help... We have some workflows getting a slack in-between change cell value (without replace) and others that don't have slack but all are set up the same and becoming invalid. Should I not be using "Has any of"?

Thanks in advance!

Screen Shot 2022-06-10 at 12.46.25 PM.png

Screen Shot 2022-06-10 at 12.46.43 PM.png

Screen Shot 2022-06-10 at 12.48.41 PM.png

I'm sorry we don't use Slack here, I'm not even sure what it does or how that might affect your workflow.

Perhaps the fact that you don't specify a particular cell change in your trigger is causing this. It see your change cell action as a new change to the same row, so it would just keep running. Try indicating an unrelated field in your trigger that gets populated when new row entries come in. So the trigger would be something like:

When rows are added or changed, when Primary Column changes to any value...

Thanks, @Jeff Reisman. I'm not getting immediate invalid alerts, so fingers crossed that was the trick to make the trigger more specific. thanks for your help!

Genesia

Is there a way with Change Cell Value, that it would update to the next recurring date?