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
Rollup latest date - known issues?
+3Best answer by ScottWorld
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.
+35I 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.
+35Oh, 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.
+3Oh, 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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.