-
I'd love some advice to build a form to collect manuscript submission data for faculty.
This discussion was created from comments split from: Manuscript Tracker.
-
Automating blueprint to create templates under existing workspace
Hello everyone, I currently have a blueprint that holds a bunch of templates. These templates get created under existing workspaces, meaning, i do not want a new workspace to get created. Currently, we're using the manual approach. when a request for these templates come in, we go into control center, and we manually…
-
How I can create a wizard to my own created models?
How I can create a wizard to my own created models? It was based in a list of models, dashboard and reports like below:
-
Report Automations Remove Link to Sheets
Hi, I have an issue and I hope there is a workaround. I have several reports created for different groups of people to view items specific to their needs. Obviously the report is derived from a master sheet. When I send a notification, I send attachments and only attachments. It confuses people when they see the link to…
-
Is there a way to have an alert triggered hourly and send to a client (non-licensed user)
We are have created a sheet to share with our client and have added them as an editor but for some reason it will not allow me to send an hourly alert to them when we add comments to the sheet. I am trying to avoid an alert that is triggered immediately when comments are entered. I am able to do this on a different…
-
Need to pick the right solution to start a project. Need Dashboard that receives updates...
Hi All, I am new to Smartsheet and need to setup a new project. I've been told the stakeholders want to view a dashboard that updates from Task Trackers from various departments. It is a large project with HR, Payroll, Tax and Insurance, Finance and Information Technology all doing a piece of the project with their own…
-
Dashboard Report Metrics - remove column headers
Hey Brainstrust, I am wondering if there is a way to remove the report column headers from a report metric on a dashboard. We add our own hearders into the grid so we can change the formatting of the column headers (centre, change colour so they stand out etc). But obviously this looks a bit odd when there are 2 sets of…
-
I just want to have a running count of entrants in a column so that I can pull this data to a dashb
I just want to have a running count of entrants in a column so that I can pull this data to a dashboard. I have been playing around with the sum and count and sumif and countif functions. I want the data to be live so that is another person submits the form (the data is from a checklist) the dashboard widget will update…
-
Block Submissions According Quota Met
Hi! I wanted to see if there is a way to block date submissions on a form if a quota has been met on the SmartSheet? For example, we are utilizing a form to submit for summer weeks. The max for each week is 4, so if a week already has 4 submitted, I would like the user to be blocked from submitting that date. Is there a…
-
Dashboard Funcionality
Hey, friends. Long time listener; first time caller. I'm stuck. Here's what I'm trying to do. I have created a stacked column graph that shows a scale of potential values in several different categories. Example: for "Blue", 0-68% is poor, 69-75% is acceptable, 76-85% is good, 86-100% is exceptional. Then there are…
