GREAT Demo! this is exactly what I needed, and it's very sad Smartsheet doesn't have this massively important aggregator available by default in the dashboard.
Yes and No. It really depends. There are cases where you have to update metrics sheets to include more values explicitly, however there are formula work arounds and skipping blanks etc that can help make it more resilient to change. Sometimes we use a report off of a metrics sheet or something along those lines... Smartsheet often upsells their Pivot Table Add-on for organizations that have lots of use cases of this sort. We've also used other add-ons to work around this use case like DataMesh and Dynamic View, etc.
GREAT Demo! this is exactly what I needed, and it's very sad Smartsheet doesn't have this massively important aggregator available by default in the dashboard.
Glad it was helpful! We agree, and we are excited that the Smartsheet roadmap includes more dashboards enhancements!!! - Very important!
Thank you! very helpful! Is there a way to have this dynamic in case more people are added to the sheet later?
I keep getting the "#INCORRECT ARGUMENT SET" any ideas?
Yes and No. It really depends. There are cases where you have to update metrics sheets to include more values explicitly, however there are formula work arounds and skipping blanks etc that can help make it more resilient to change. Sometimes we use a report off of a metrics sheet or something along those lines...
Smartsheet often upsells their Pivot Table Add-on for organizations that have lots of use cases of this sort. We've also used other add-ons to work around this use case like DataMesh and Dynamic View, etc.
So many ideas - one of the most common issues with formulas. Did you get it fixed?
Exactly what I was looking for. Thank you!
So glad it was helpful @Joy!
Amazing!! Thank you - you made this soooo much easier.
Glad it helped! Thanks for the great feedback!
Thank you SO MUCH. This was driving me crazy lol
We know the feeling! So glad it was helpful 😊
Many thanks!! this was really helpful
You're welcome! We're so glad it was helpful :)