Help

Re: If formula help

787 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Mike_Coghill
5 - Automation Enthusiast
5 - Automation Enthusiast

We have built a pretty good CRM within Airtable. We are constantly adding new things to it to make sure the data that we are seeing from it is as useful as possible.
I am trying to add an if statement that if a customer has not been interacted with withing 30 days it is flagged using an if statement.
Here is what i was trying to use and its not working
IF(DATETIME_DIFF(NOW(), {Sales Interaction},‘days’)>30,“ :rotating_light: “,””)

If anyone could help out id be grateful as im sure it is something easy.

Thanks,

4 Replies 4
Ron
4 - Data Explorer
4 - Data Explorer

I tried your IF statement and it worked for me. In the Day Diff field I used this formula:
DATETIME_DIFF(NOW(),{Sales Interaction},‘days’)

image.png

Mike_Coghill
5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks that was helpful I figured out where the error was.
Another question if I wanted on a separate table within the view count the amount of accounts that have been flagged how would I go about this?

What the error was? :grinning_face_with_sweat:

Calculating off of a linked record wasnt wwroking had to create a static date to create off using the a function.
Should have thought of it.