Hello,
I’m trying to get this field to show only the most recent entry. The field is a rollup from another table, showing different kinds of interactions, so the result in the field is something like this:
call no show, followed up, etc
And I want to create a field that will return only the most recent one. I’ve tried a bunch of different things I’ve found in this forum, but nothing is working so far…
Any ideas?
Thanks!
+14Can you try something like rolling up the Created Time using MAX(values).
Then use a Look Up field in the table you rolled up from to look this value up. Then use a formula to display the type of interaction if Created Time is the same as the rolled up maximum time…
IF( {Created Time}={Max Time}, {Type of Interaction}, BLANK() )
Then use a Roll Up or Look Up in the other table to get the interaction.
(I have not tried this, but it is probably how I would attempt it)
Can you try something like rolling up the Created Time using MAX(values).
Then use a Look Up field in the table you rolled up from to look this value up. Then use a formula to display the type of interaction if Created Time is the same as the rolled up maximum time…
IF( {Created Time}={Max Time}, {Type of Interaction}, BLANK() )
Then use a Roll Up or Look Up in the other table to get the interaction.
(I have not tried this, but it is probably how I would attempt it)
Thanks for your idea!
I actually figured out that the reason nothing was working… was that I was trying to operate off of a lookup field instead of a rollup field. DOH!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
