This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hello,
I am trying to use Last Modified Date for particular fields to evaluate whether those fields were updated today, and if so, concatenate those updated values, separated by commas, and output those into my formula field. The final formula resul...
This worked perfectly, thank you!! Here is the final formula:
IF(
{LM DS: Winter Instructor}={LM DS: Last Update Today Equiv},
CONCATENATE("Winter Instructor",", ")
) &
IF(
{LM DS: Winter Section #}={LM DS: Last Update Today Equiv},
C...
Hello,
That edit worked for getting the formula to return the concatenated values, thank you!!
I am trying to get the formula to only return updated fields for this, but haven’t figured it out yet. I was last working on this after a long workday, so...
Thank you so much for this tip!! I was surprised to find that AirTable doesn’t allow for wildcards in formulas or “starts with” in filtering views, but this workaround is perfect! :star_struck:
