Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jun 17, 2022 11:31 PM
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.
Any ideas? Many thanks in advance!
Cheers,
M
Solved! Go to Solution.
Jun 17, 2022 11:52 PM
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.
Jun 17, 2022 11:40 PM
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.
Jun 17, 2022 11:52 PM
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.
Jun 18, 2022 12:28 AM
Scott, you just saved my life. THANK YOU!