-
Formula Help
Hey guys, I need help to put a formula in my sheet that can sum all 'Type A' column that are from a specific campaign and specific market. for example all total of type A for Jazz (campaign) AT (market) I thought it would be something like, but neither are working =SUMIFS(Campaign:Campaign, "Jazz", Market:Market, "AT",…
-
How do I update the Parent Cell so that anytime one of the candidates (listed in the Child Cells)...
is marked as "Hired" as the Status, it then doesn't count that row? For reference, see the first Parent Column "Accounting - 3 Openings" - however, there is only 1 opening that doesn't have the status as hired and it's not showing that...I tried to add conditional formatting to change the row to "Green" if status is Hired…
-
How to count number of projects in 2023 by current status
Hi, I created a Metrics sheet that feeds a dashboard last year that counted the status of a variety of items and it worked great when there was just one year. This year, I now need to only count the items that are for 2023. In the main sheet, I have a column that has the year in a string format (it's a formula…
-
Expand library of approved domains for the embedded widget on dashboards
Our department utilizes Maptive for map creation on various information/data. It would be helpful to expand the library of approved domains to include maptive.com to the dashboard embedded widget. Thank you, Pamela
-
What's the best way to get a total count and also categorize the results?
I'm creating a dashboard for our team on submitted tickets but the requestor wants this data to show total ticket amount per team member and also have it broke down into completion dates. Ex: Jane Doe: Total Tickets 100 Completed 1 day or less - 50 Completed in 2 days - 25 Completed in 3 or more - 50 I'm pulling this data…
-
Stacked bar chart that only goes to 100%
Hi, I'm trying to create a stacked bar chart that combines the Actual number, the Deal Model Number, and the projected number into one line. I'd like the bar chart to only go to 100% and as the Actual number goes higher, it shows it creeping up the bar towards the deal model / projected number. I'm not even sure what kind…
-
Reporting/dashboard on form entries
Our Referrals departments has recently started utilizing a smartsheet form to track key information on each referral that comes into our hospice. Each team member completes & submits the form when they get a referral. I have the sheet set to automatically date/time stamp each row as it comes in. The department heads are…
-
Can I display row numbers in Dynamic View on a Dashboard?
We have a client dashboard with a dynamic view showing progress of our projects. Is there a way to have the row number, that typically displays on the report or sheet, show up on the left of the line? Thanks!!
-
Project Brief or Project Charter in Dashboard Format?
Hi there, Has anyone created a dashboard template for a Project Brief or Project Charter? I'm looking for an easy way to compile project information and share during our steering committee meetings. Many thanks, Jasmine
-
Rolling up RYG status by workstream
Hello, I'm looking to write a formula that averages my health status, but by the workstream column. For example, in the screenshot below, I'm looking at the "Equipment and Technology" workstream. I am using a separate metrics sheet to write the formula, as there will be one roll up status for each of my workstreams…
