Formula for auto-updating single select fields

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 :slight_smile:

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

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!

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.