Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Rollup latest date - known issues?

Solved
Jump to Solution
183 3
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi all,

I’m using Rollup to find the latest date in a custom CRM. The Max(values) approach always works fine, but in this instance I cannot select “date” as an option under the format menu in Rollup.

Screen Shot 2022-06-17 at 11.30.41 PM
Screen Shot 2022-06-17 at 11.30.31 PM

Any ideas? Many thanks in advance!

Cheers,
M

1 Solution

Accepted Solutions

Oh, I just noticed that your term “Values” is in purple. This purple color represents a field name. You probably have a field named “Values”, which triggers a massive bug in Airtable where rollup fields can never be used. The only way to workaround this is to never name any of your fields “Values”. Trust me, there is no shortage of bugs in Airtable. Lol.

See Solution in Thread

3 Replies 3

I am not seeing that incorrect behavior on my end. I am seeing the proper behavior. I would recommend opening a ticket with support@airtable.com.

Oh, I just noticed that your term “Values” is in purple. This purple color represents a field name. You probably have a field named “Values”, which triggers a massive bug in Airtable where rollup fields can never be used. The only way to workaround this is to never name any of your fields “Values”. Trust me, there is no shortage of bugs in Airtable. Lol.

Scott, you just saved my life. THANK YOU!