Skip to main content

I want to make a formula or automation to do the following task:



Step 1


When a single or multiple select field has a status “Revisit” 2⃣



Step 2


I need to automatically have a 4⃣ Date 2 for the specific record with the status “Revisit” 2⃣ , 30 calendar days after 3⃣ Date 1.



Note 1


The issue I face when trying to create a formula field is that the secondary date applies to all records, which I don’t want. Just for “Revisit” 2⃣ .



Note 2


I am not too sure if I can create conditional logic automation to perform this action. This is what I have attempted to no avail.


Trigger


When a record is updated with the status 2⃣ “Revisit”



Conditional Action


If 3⃣ Date 1 is not empty


Update 4⃣ Date 2 +30 Days



Any Suggestions?



This is the structure to the logic:


1⃣ Address (Main)


2⃣ Single or Multiple Select Field


3⃣ Date 1 (European)


4⃣ Date 2 (Formula or Automation dependent on 3⃣ )

Automations can’t perform any calculations, so you will need to create your formula field in advance. Yes, it will show up for every record in your entire database, but you can just hide the formula field so you don’t see it. Then, in your automation, refer to this formula field to get the date that you want.

Does Date 2 need to be editable? Or does it only ever have a value when the select contains “revisit”?



Does this formula work for you?



IF(


    FIND(


        'Revisit',


        {Select Field}


    ),


    DATEADD(


        {Date 1},


        30,


        'days'


    )


)

@ScottWorld Thanks a lot of your reply. That’s what I thought but have still been figuring our the new conditional actions for Automations.



However, I have used your formula @kuovonne and works like a charm! Thank you so much. Date 2 does not need to be editable and can be fixed (formula style). My main use for this is to identify when my client needs to be informed to revisit records with a specific single or multiple select fields (using Airtable Automations). This formula is great and I really appreciate it!



Valentino

Reply


Terms & Conditions