SG_SoCal - profile

SG_SoCal · Aug 05, 2022

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...

SG_SoCal · Aug 10, 2022

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...

SG_SoCal · Aug 08, 2022

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...

SG_SoCal · Aug 15, 2020

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:

User Statistics

User Activity

Formula for finding matching field values and returning those in one place

Re: Formula for finding matching field values and returning those in one place

Re: Formula for finding matching field values and returning those in one place

Re: Filter by "starts with" "ends with"