How do I create a formula or workflow to auto select 1 columns value based on another columns value?

I have 2 columns that I was to use together to provide a sort of checks/balances system for missing information. See columns and values example outline below:

Column 1:

Value 1

Value 2

Value 3

Column 2:

Value 1

Value 2

Value 3

The Values would be the same under both columns, but when a value or values are selected under Column 1 I want to unselect them in Column 2. So with that I would want to have all the values selected under Column 2 automatically. For example, to start column 2 will have all 3 values checked off/selected - then at some point when Value 1 under Column 2 is selected then I would want Value 1 under Column 2 Deselected.

I'm not sure if there needs to be a hierarchy created in order for this to work but if so I would say having column 1 be the parent column between the 2 would be best.

Thanks for your help!

Find more posts tagged with

Accepted answers

All comments

Genevieve P.

Hi @Cameron Ostafin

I would suggest using the Change Cell workflow action to achieve this!

If you have both Column 1 and Column 2 configured as MultiSelect columns, you could set up a rule so that Column 2 adjusts based on what is added or changed in Column 1:

Screen Shot 2022-02-28 at 11.42.53 AM.png

See Change the Value of a Cell in an Automated Workflow and Condition Blocks: Filter What Your Automated Workflows Send

Cheers,

Genevieve

Cameron Ostafin

Thanks for the help Genevieve! I'm trying to test it out like you have it mapped above but it's not allowing me to do it how you have it. Not sure if I need to see more of your screenshot to understand why but when I try to recreate what you have it doesn't allow me add conditions side by side and have a separate "Change cell value" rule for each condition. Not sure what I'm doing wrong. Any ideas?

Genevieve P.

Hi @Cameron Ostafin

To add multiple conditions, click the blue + sign above the first condition and select the option to "Add a Condition Path":

Screen Shot 2022-03-03 at 12.26.04 PM.png

Then after you've added another block, go back to that same + button and do it again!

Screen Shot 2022-03-03 at 12.26.10 PM.png

Let me know if this helped or if I can clarify anything further!

Genevieve

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.