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?


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!