megtro610
megtro610
Discussions
- I am new to Smartsheet and making a dashboard. I want a widget to show as a pie chart illustrating how many : 1. "SRM"(child rows w/ purple check marked and bold text) there are [see screenshot below]…
- I am trying to make a widget for a dynamic dashboard that shows how many child level 2s and if the "Closed?" box is checked or not. I would like to make it a pie chart if possible. The level column is…
- I am trying to make a metric sheet to populate information for a dashboard. The originating sheet is from a survey/form. I would like to count how many times each category is paired with the Highest L…
- I am very new to smartsheet. What formula would I use to count how many times the year 2021 appears in the blue (parent) rows? I also would like to make a formula for a metric sheet that automatically…
- I am making a dashboard, and I would like to make the specific year's number change as I add/ delete sections in my sheet. (right now each number is manually typed from a report I made). I have each i…
- I am making a dashboard, and I would like to make the specific year's number change as I add/ delete sections in my sheet. (right now each number is manually typed from a report I made). I have each i…
- I am making my first dashboard, and I'm wondering if there is a way to make a report appear in the report section when clicking on a widget. For example, I would click one of the dates below, and a re…
- In my metric sheet, I am receiving the #INCORRECT ARGUMENT SET error on code I made trying to only count the child rows in my reference sheet. =COUNTIFS({Is it implemented?}, 1, {evidence attached 1},…
- I am making a dashboard widget to show how many items in the implemented mitigations column are checked and how many are not. I understand that I may need to make a report or a sheet summary to do so …
- I am trying to make a metrics sheet that shows how many checked boxes there are in my sheet. The tutorials I found said that "true" and "false" mean whether the box is checked or not. Why are my resul…
