#INVALID REF for Widget

Hi Community. I'm hoping someone can help me out. I created a task tracking sheet. A general rule is that our reporting month is always two month behind today. In my sheet summary I have a formula using index match, which works perfectly to my expected results. I am using a date reference table so I can see the month name instead date format.

The issue I am having is whenever use the sheet summary to create a metric widget, it states it is an invalid reference. Anyone know what gives? I would like my dashboard to be as dynamic as possible not require a lot of maintenance.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!