Formula for auto-updating single select fields

[Ebba]

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:

[Nathalie_Collin]

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")))

[Ebba]

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?

[Nathalie_Collin · Accepted solution]

Ebba:

That worked perfectly

Great news!

Ebba:

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?

I’m not sure to be honest.

Enjoy the rest of your weekend!