Help

Roll up max date but show another field

Solved
Jump to Solution
2066 2
cancel
Showing results for 
Search instead for 
Did you mean: 

I have two linked tables A & B
A contains different projects
B is where staff is logging different tasks linked to different project at different dates.

I’m trying to roll up a the latest logged task for each project back in A.

I tried rolling up MAX(values) but it only works on dates, so will not show the latest task field back in A.

Is there any way to rollup a field based of the latest date?

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus

Kinda. If you keep your MAX(values) rollup in place, add a lookup field to [Table B] which reports the maximum date for all tasks assigned to the project. Then add a formula field with something like IF({Date field} = {Lookup field showing max date}, {Task name/description field}). Then you can rollup that field in [Table A].

There may be a more elegant solution, but this one is the first to come to mind. Obviously you can hide the extra rollup/lookup fields so your base doesn’t appear cluttered.

See Solution in Thread

2 Replies 2
Kamille_Parks
16 - Uranus
16 - Uranus

Kinda. If you keep your MAX(values) rollup in place, add a lookup field to [Table B] which reports the maximum date for all tasks assigned to the project. Then add a formula field with something like IF({Date field} = {Lookup field showing max date}, {Task name/description field}). Then you can rollup that field in [Table A].

There may be a more elegant solution, but this one is the first to come to mind. Obviously you can hide the extra rollup/lookup fields so your base doesn’t appear cluttered.

Beautiful - thank you. I didn’t think about it this way.