Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Dashboard / Report - Labeling

✭✭✭
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.


Capture.PNG


Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions