I have a sheet which lists loads of data on one column there is a selection of option (open, closed, etc....) Is it possible to put a widget or chart on dashboard showing the quantity of each option?
Hi Anna,
From what i know you will have to do the calculations somewhere in the sheen and then pull it to the chart.
See example of the calculations below.
It means you will need to have a small table, one value for each status and calculate count-if based on the status and then add the widget with this data
Hi Smartsheet Community, I’m looking for some help setting up a way to track reviewer submissions across three different sheets. Here’s the setup: We have three sheets (one for faculty, one for students, and one for scholarships). Each sheet lists applicants, and in each row we assign three Selection Committee (SC) members…
Hi, I'm having an issue where the graphs in the dashboard are auto scaling to the numbers in the table. I was hoping to get a scale of 100 for each of my graphs on my dashboard but there's seem to be no way to update this. Would anyone know how to update this?
Hi, I'm having issues trying to get my automation to function. I have tried it numerous ways and it still doesn't work. Basically, if anything but New York is selected, I want a link email to go out with an additional form I need to fill out. Here is what my workflow looks like: I just cannot figure out what I'm missing…
