Skip to main content

I have created a Rollup field in my Contact table which searches within the Touch Points linked table and rolls up the 'Start Date/Time' field using the 'MAX(Values)' aggregation formula. My challenge is that I am unable to get a date which I can then filter to appear inside my Rollup field. The Formatting tab does not have the option for date as per screenshot:

https://share.getcloudapp.com/X6uKqr7Q

https://share.getcloudapp.com/9ZuKv2yy

Any input would be appreciated. Video included below for more context if necessary:

https://share.getcloudapp.com/rRugpPzA

Thank you!

Hey @Kosta_Kondraten! 

Change your rollup formula from: 

MAX(Values)

to...

MAX(values)

I can see from your screenshot that your table also has a formula field called "Values."
In rollup formulas, the values variable is case-sensitive.

The telltale sign that your formula is referencing a field on a local table is if the formula syntax highlighting turns the field name that you're referencing into purple text.

 

Hey @Kosta_Kondraten! 

Change your rollup formula from: 

MAX(Values)

to...

MAX(values)

I can see from your screenshot that your table also has a formula field called "Values."
In rollup formulas, the values variable is case-sensitive.

The telltale sign that your formula is referencing a field on a local table is if the formula syntax highlighting turns the field name that you're referencing into purple text.

 


Thank you so much!!!

Reply


Terms & Conditions