Summary Formula

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?

Find more posts tagged with

Accepted answers

All comments

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 ),)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.