Skip to main content
Solved

Formula for auto-updating single select fields

  • August 23, 2020
  • 3 replies
  • 50 views
E

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:

Best answer by Nathalie_Collin

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!

This topic has been closed for replies.

3 replies

Nathalie_Collin
Forum|alt.badge.img+18

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

E
  • Ebba
  • Author
  • Inspiring
  • August 23, 2020

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?

Nathalie_Collin
Forum|alt.badge.img+18

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!

    Terms & ConditionsAccessibility statement