Help

Formula for auto-updating single select fields

Topic Labels: Formulas
Solved
Jump to Solution
1586 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Ebba
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi everyone!
I was wondering if someone may be able to assist. I am quite new to Airtable and just getting my head around formulas. I am looking to create a formula to auto-update the STATUS of a client depending on how many jobs we have done for them.

  • I have created a STATUS column which contains the three single-line field options of HOT WARM and COLD.
  • I have another column which records the AMOUNT OF JOBS we have done as a number.
  • COLD would = 0 visits, WARM = 1-4 visits, HOT = 5+ visits.
    Is there is a formula I could use for this?
    Thank you so much in advance :slightly_smiling_face:
1 Solution

Accepted Solutions

Great news!

I’m not sure to be honest.

Enjoy the rest of your weekend!

See Solution in Thread

3 Replies 3

Hi @Ebba,

Unfortuatnely, you can’t use a formula to change the results in a single select field. You could instead use a formula that gives you the same desired results though.

Perhaps you could consider; IF({Amount of Jobs}>=5,"HOT",IF({Amount of Jobs}>=1,"WARM",IF({Amount of Jobs}=0,"COLD")))

image

That worked perfectly. Thank you Nathalie!

Another quick question - when I scroll down through the base it jumps back to the beginnin for some reason. I see other people have experienced the same thing. Any solutions to this one?

Great news!

I’m not sure to be honest.

Enjoy the rest of your weekend!