Help

Rollup field to display date format of latest related date

Topic Labels: Base design Formulas
Solved
Jump to Solution
1151 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Kosta_Kondraten
7 - App Architect
7 - App Architect

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!

1 Solution

Accepted Solutions
Ben_Young1
11 - Venus
11 - Venus

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.

 

See Solution in Thread

2 Replies 2
Ben_Young1
11 - Venus
11 - Venus

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