Summary Formula

Archie

I'm trying to get a formula set up in the sheet summary to get rows added within the last 90 days, and then a vlookup to get a cell value.

I've tried numerous formulas but they're all coming up with an error

=IF(TODAY() - Created:Created <= 90, VLOOKUP("Reviewer", [Peer / Reviewer Rating]:Trust, 10, false),)

any ideas please?

heyjay

Can you try to replace Created:Created with [Created]@row. I also suggest to try to use INDEX MATCH instead. This way, even if the Table Range, you wont have any issue.

The also seems to be something wrong this this part  [Peer / Reviewer Rating]:Trust

And this part seems incomplete ),)