Dashboard / Report - Labeling

strobn ✭✭✭
edited 03/24/23 in Formulas and Functions

I am building a dashboard based off a report that was created from Sheet Summaries of 4 different sheets. The widget below shows 2020, 2021, 2022, and 2023 YTD. I would like for either the blue dot or the base of the column to reflect the year associated with the values.

I am certain it must be somewhere earlier in the process, and yet struggling to determine what to modify to make this happen? Currently the date is based simply on the Sheet, and information is not located in a column.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!