The Airtable Community will undergo scheduled maintenance on September 17 from 10:00 PM PST to 11:15 PM PST. During this period, you may experience temporary disruptions. We apologize for any inconvenience and appreciate your understanding.
Hello community,
I have seen a few topics similar to the one above (Last Modified Timestamp) and (Most Recent Date from another table).
I am using this for project management. I want to see either:
How many times the “Due Date” field has been updated...
I have a base that we use for activity management. I want to have a way to count the number of times a date field has been updated. I thought there might be a count() formula that could do this but it only counts current status rather than the number...
Hello!
I am relatively new to Airtable and am trying to figure out why my nested IF statement isn’t working.
Goal: If the due date field value is before today and the field complete is not checked show “in progress”, if complete is checked then show ...
Hey @W_Vann_Hall - thanks for the input here. Just trying to follow what you are talking about here for #2. Could you give an example? In what I am trying to do I am picturing having to create a new table in the Master DB that just has ID and CREATED...
I know this is an old thread, but this seems like the same issue that I am having.
I have 3 bases within one account. Each team has their own base. I want to create a master record of the three separate bases.
Right now any time that there is a new r...
+1 to this feature. I understand the tricky UI this poses due to needing to “warn” a user of the potential changing position, but I think this would be a valuable piece of automation.
This is super helpful. I was able to get what I needed with two separate formulas shown below:
IF({Due Date} >= TODAY(), "In progress", "Missed")IF(Complete = 1, DATETIME_FORMAT(TODAY(),"l"), {Completed Date (Dependent Field)})
I think your solution ...
Hey Elias,
Thanks for the info! I have two questions about those ideas.
How is the “IS BEFORE” built into the parameters? If I removed that, my assumption is that it would just evaluate if it is today or not today rather than giving me the ability to...