Looking to return a value given a specific row and column
Mike Ferringer
✭✭✭✭
I would like update a goal target automatically based on today's date from a matrix. Through "=Today" , I have established the current year and current month. From there I want to populate the yellow cell in the "Current Goal" column for either "Annual" or "Cumulative". This cell will then be cross-linked to a metrics sheet containing actual performance and then set forth in a graphical form in a dashboard report.
Looking for some help on this...through a conditional formula, or filtering or ???
Answers
-
Ignore this post. Found another way to accomplish by restructuring the sheet and utilizing "Index/Collect" function.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!