Using TODAY() in a Sheet Summary

I am trying to get a sheet summary formula to report a cell based no todays date. I tried the following formula (and a few similar variations) with no luck. What am i doing wrong? should i be going the vlook

up route? Thanks!

=IF(Date:Date = TODAY(), [Total Completed C-Boxes]@row,"")


Best Answer

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭
    Answer ✓

    @TroyT

    Try an INDEX/MATCH there. I like INDEX/MATCH over VLOOKUP because it will still work even if columns get moved around in the sheet.

    =INDEX([Total Completed C-Boxes]:[Total Completed C-Boxes], MATCH(TODAY(), Date:Date, 0))

    In English - find the value in the [Total Completed C-Boxes] column on the row where the Date value equals today.

    Regards,

    Jeff Reisman

    Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages

    If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!