Jodie_Kolbeek - profile

Jodie_Kolbeek · Aug 13, 2021

Hello, I am looking for some help. I’m pretty new to Airtable, so I don’t know if what I am looking for is possible. However, I want to create a formula with the below logic. IF value in column A IS "YES" > 30 minutes THEN "Needs action". I then want...

Jodie_Kolbeek · Aug 16, 2021

Not unlikely that I missed it in my copy-paste @Justin_Barrett!

Jodie_Kolbeek · Aug 16, 2021

@Justin_Barrett, your assumptions are correct! I’ve added the formula and will have it run for a couple of days to see if it does what I want it to do (reading your and @kuovonne explanation, it should!) For future reference: I got a ‘formula not acc...

Jodie_Kolbeek · Aug 16, 2021

@kuovonne, Thank you! I’ve tested it out and it seems like your formula works! Now, to add a difficulty level to my request, ideally the formula reference multiple columns (5 to be precise). Can I nest those by simply using 5 additional AND statement...

Jodie_Kolbeek · Aug 16, 2021

Hi @Justin_Barrett, Thank you for coming back so quickly and explaining the logic! To answer your questions, Column A is a single select (YES/NO or Stopped/Live). But the value that appears is based on a script that’s running in the background. It is...

User Statistics

User Activity

Using last_modified_time in an IF statement

Re: Using last_modified_time in an IF statement

Re: Using last_modified_time in an IF statement

Re: Using last_modified_time in an IF statement

Re: Using last_modified_time in an IF statement