New to charts and metrics. I have been sitting in front of the computer for hours trying to make sense of Smartsheet instructions and this just answered my questions in less than 30 minutes!!! Thank you!
Awesome instruction! I made it to work in my practice sheet! Although i have a question, How to let Metric Sheet' data automatically update, after changes are made in the referenced sheet? I've tried to make some update on the main sheet, but the Metric did not change.. The only solution i could come up with is by updating the Formula to have the same formula over again and refresh the sheet. Is there any other way?
Hmmm, it should push after you save the underlying sheet data and refresh the dashboard. Sometimes we use a date record automation to record a date every day in the metrics sheet so that the sheet refreshes. I may be missing something since you mentioned repeating the formula, which I'm not sure why that would help / be necessary.... Perhaps a bit more context?
Thank you for this, its extremely helpful. One question, how do you eliminate the parent rows that being calculated in reference sheet? I only want the sub category total. Thank you
Great question! You would need to have a helper column that signifies which rows are parent rows, and then add that as criteria in the formula. The formula for that sum would be: =IF(COUNT(CHILDREN()) > 0, 1, 0) . Let us know if this helps!
Video was helpful, but your formula you used to calculate "Due in Next 7 Days" was incorrect as it was giving you the exact same numbers you had for "Opened in Last 7 Days". You had also never circled back to show the calculation for "Closed in the Last 7 Days".
New to charts and metrics. I have been sitting in front of the computer for hours trying to make sense of Smartsheet instructions and this just answered my questions in less than 30 minutes!!! Thank you!
Glad it helped! Please feel welcome to share any questions in future comments!
I am new to using Smartsheets, and this was extremely helpful. Thank you!
So glad to hear that @Jodi! Smartsheet is a powerful and flexible platform! We love helping get the most value out of it!
Awesome video! Thanks so much for your professionalism during this training.
Our pleasure!
SO incredibly helpful as I navigate creating a project portfolio, thanks Kelly!!
So glad we could help! Subscribe and we will be releasing more videos soon!
Awesome instruction! I made it to work in my practice sheet! Although i have a question, How to let Metric Sheet' data automatically update, after changes are made in the referenced sheet? I've tried to make some update on the main sheet, but the Metric did not change.. The only solution i could come up with is by updating the Formula to have the same formula over again and refresh the sheet. Is there any other way?
Hmmm, it should push after you save the underlying sheet data and refresh the dashboard.
Sometimes we use a date record automation to record a date every day in the metrics sheet so that the sheet refreshes.
I may be missing something since you mentioned repeating the formula, which I'm not sure why that would help / be necessary.... Perhaps a bit more context?
Thank you for this, its extremely helpful. One question, how do you eliminate the parent rows that being calculated in reference sheet? I only want the sub category total. Thank you
Great question! You would need to have a helper column that signifies which rows are parent rows, and then add that as criteria in the formula. The formula for that sum would be: =IF(COUNT(CHILDREN()) > 0, 1, 0) . Let us know if this helps!
Very helpful. Thanks very much!
Glad it was helpful!
Video was helpful, but your formula you used to calculate "Due in Next 7 Days" was incorrect as it was giving you the exact same numbers you had for "Opened in Last 7 Days". You had also never circled back to show the calculation for "Closed in the Last 7 Days".
Yes, you are right! Got distracted! - Here is our video on formulas : th-cam.com/video/hAJ_cB7VcCw/w-d-xo.html