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