-
New Sheet -- Announcements Message
Hi, Is there a way to have a welcome screen or alert come up when a person goes into a sheet. I would like the sheets comments to pop up on new sheets or like an announcement on already existing sheets.
-
Volunteer Allocation
Hi All, I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific locations (we do not know these specific locations until last minute). I have built a survey…
-
Want to create a sheet with associated dashboard and reports that is a template
I want to create a sheet with associated dashboard and reports that is a template bundle, so when I click on the "Use Template" button, the new reports automatically get data from the new sheet and appear on the new dashboard. I don't want to have to re-associate the new reports to the new sheet and the new reports to the…
-
workspaces and templates not appearing in Zapier
I am the owner of the workspaces and templates - Admittedly I do not know if this in on the Zapier side, but I seem to be missing several options when using Zaps to create new sheets from a template. The system does not see the destination (workspace) I want to new sheet to go in, nor the template I want it to create. What…
-
Using Smart Sheet and Web Form to manage testing
Hi, Are there any recommendations you can provide to using Smart Sheet and Web Form as workaround to traditional testing applications to manage repetitive testing (case management and result gathering) across multiple users performing same test case? I'm currently using a reporting template but there are numerous…
-
"Smartsheet Formula Examples" template cell references issues
The "Smartsheet Formula Examples" template, while very helpful, appears to have a variety of issues with cell references that have been moved over time. Somewhere around row 26 things start to get weird. Is this only on my copy of this sheet? I did delete it from my workspace and reload it to see if it would be fixed, but…
-
Combining multiple views of a project plan in one
In our previous solution, we had five project plans for users to choose from. This caused reporting issues as our milestones did not align between project plans. Has anyone combined project plans into one template and allowed the user to see the appropriate tasks for their chosen project plan by perhaps a filter? Example,…
-
Auto-applying Jira Status Updates from a central sheet, back to a specific Project Plan sheet
We use a standard project plan (~100 tasks/steps) as a template for our team, and it gets copied for each new project. There are ~6 tasks on the project plan that drive Jira task ticket creation. Instead of adding extra columns to the standard project plan sheet (since they'll be blank for most rows), we link the task on…
-
Maintaining multiple sheets with the same format
I created a tracker that I then created 20 copies of and each one is used by a different team. The sheets all have the same workflows/conditional formatting. The business owner keeps wanting to make tweaks to the sheet (like to add a column or something) and it is very time consuming to do that to each individual sheet. Is…
-
Conditional Logic Forms
We have a form that will have yes/no logic. If Yes(problem is resolved with the previous information provided in logic) is selected we want them to back out of the form or display a "thank you, please submit if you have any additional questions" It doesn't appear the functionality is there, but does anyone have work around?
