Skip to main content

If formula help

M

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

    R
    • Ron11
    • New Participant
    • 1 reply
    • January 25, 2018

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

    M
    • Mike_Coghill
    • Author
    • Participating Frequently
    • 5 replies
    • January 25, 2018
    Ron11 wrote:

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


    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?

    E
    Forum|alt.badge.img+17
    Mike_Coghill wrote:

    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:

    M
    • Mike_Coghill
    • Author
    • Participating Frequently
    • 5 replies
    • January 25, 2018
    Elias_Gomez_Sai wrote:

    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.

    Reply


    Most helpful members this week

    Terms & Conditions