Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

# Multiple If Statements Based on Multiple Data Points

Topic Labels: Formulas
171 1
cancel
Showing results for
Did you mean:
4 - Data Explorer

I have tried multiple Nested If statements to achieve this result:

This is my ultimate goal:

If “Date of Last Contact” is blank then return blank.
If it is not, then if “Days Since Contact” is ❤️ then return “ :heavy_check_mark: Less Than 3 Days :heavy_check_mark: ”
If it is not, then if “Days Since Contact” is <5 then return “ :warning: Almost More than 5 Days :warning: ”
If it is not, then if “Days Since Contact” is >5 and Status Does Not = Revisit Later then “ :x: Greater Than 5 Days :x: ”
If Status = “Revisit Later” and “Days Since Contact” is >30 then :x: Time To Revisit :x:
If not then leave blank.

IF({Date of Last Contact} = BLANK(),BLANK(),IF({Days Since Contact}<=3,“ :heavy_check_mark: Less Than 3 Days :heavy_check_mark: ”,IF({Days Since Contact}<=5,“ :warning: Almost More than 5 Days :warning: ”, IF(AND({Days Since Contact}>5,{Status}NOT(“Revisit Later”), “ :x: Greater Than 5 Days :x: ”, IF(AND({Status} = “Revisit Later”, {Days Since Contact}<30, BLANK(),IF (AND({Status}=“Revisit Later”, {Days Since Contact}>30,“ :x: Time To Revisit :x: ” ))))))))

16 - Uranus
``````IF(
{Date of Last Contact},
IF(
{Days Since Last Contact} < 3,
"Less than 3",
IF(
{Days Since Last Contact} < 5,
"Almost More than 5 Days",
IF(
AND(
{Days Since Last Contact} > 5,
{Status} != "Revisit Later"
),
"Greater Than 5 Days",
IF(
AND(
{Days Since Last Contact} > 30,
{Status} = "Revisit Later"
),
"Time to revisit"
)
)
)
)
)
``````

Note: the field will show nothing if its been exactly 5 days since last contact.