Dashboard Metric sheet formulas
I am new to Smartsheet and have been tasked to make a Dashboard that feeds from a large spreadsheet.
I have created a metrics sheet and for the most part, it works well for the dashboard, but I haven't been able to solve the following issues;
1) How do I make the metrics sheet update when a new entry is made in the main spreadsheet- ie: if a manager adds a new 4th "modality" that isn't currently on the metrics sheet list of 3. Can this be automated?
2) Is there a formula that can "count" spots that are blank, or should a drop down option of NA or TBD be added to the main spreadsheet?
3) Is there a formula that could capture the information if the cells on the main sheet are a multi-dropdown, and more then one option has been selected?
Thank you so much!!
Help Article Resources
Check out the Formula Handbook template!