Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

IF Single Select then Change or Switch Single Select

Topic Labels: Formulas
239 3
Showing results for 
Search instead for 
Did you mean: 

Hi There,
I have two single select columns and I would like some of them to follow one another. Say for instance if I select “ON HIRE” in one single select column I would like the other single select column to automatically select “ON HIRE” as well? can this be done, any help would be greatly appreciated.

3 Replies 3

Hi @Christopher_Murdoch
This can be done with Automations, no need to write a formula.

Since you mention that only some of them should follow one another, Automations might be your best option as you can make it conditional.

Hi @Vivid-Squid,

That makes sense, although I am having difficulty working it out. I am assuming I need the use the trigger ‘When a record is updated’ however when working the configuration it gets confusing. Can you give an example or how I could get a single select column to follow another single select column using the automation function?

I am happy to help. One thing I forgot to ask is if the two drop downs are in the same table. You didn’t say they are in separate tables so I am assuming they are in the same table. Its OK if they are not but that changes things a bit.

Also the situations where you don’t want the two fields to match are unknown so I don’t know how you want that set up.

Here are all the screenshots and settings I made to match two dropdowns in the same table: