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