-
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.
-
Sheet Security - Prevent Sheet Export and Printing
Is there a way to prevent sheet from being able to be exported and / or printed? We have multiple users accessing data with sensitive information on a sheet, however we wouldn't want those users printing or exporting that data, but still keep the access to edit the data on the sheet. Any thoughts?
-
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…
-
Index/Collect/Match help
Hi I have a sheet that has epics, stories, tasks and I want to extract only the epics to another sheet. layout is simple Name IssueType Epic 1 Epic Story 1 Story Story 2 Story Task 1 Task Task 2 Task Epic 2 Epic Story 3 Story Story 4 Story Task 3 Task Task 4 Task I want the other sheet to only have Epic 1 Epic 2 thanks so…
-
Gannt chart start date does not match the date column
Hi, Pretty long project, spanning a bit over a year. I'm about halfway through it & the Gannt Dates started getting weird. In the image, Look at "Floors", predecessor 232. The scheduled start date column says 8/13, but the gannt displays the bar starting at 8/14. I dont know if this is related, but the scheduled start…
-
Formula/pie chart help?
I'd like to have a pie chart that shows a dynamic count of orders "pending/fulfilled/cancelled" of the last seven days. Ideally, there would be four separate ones for four locations (which will be presented on their personal dashboards), as well as a master graph that compiles the data for all four into one for upper…
-
Form from one sheet populates another sheet
Hello SS gurus, I am relatively new to SS "in the field", although I've watched over 20 hours of videos from the SS Learning Center so I have a good understanding of the mechanics. Here is what I'm trying to do... We need to track inventory in our supply room: items on hand, items removed, items added, etc. We would prefer…
-
Enable Form text entry when Dropdown List is not restricted
When a column is a Dropdown List, one can choose whether or not to "Restrict to dropdown values only," however, when a Dropdown List column is used in a Form, only the dropdown values can be selected. Please update the Form functionality to allow free text entry if a dropdown value is not selected.
-
Pasting from Excel triggers an Automated Workflow
I received numerous one liner emails daily from a customer with consistent data I need to action against. I'd like to paste from Excel into a Smartsheet GRID and then a workflow be triggered to validate information and email notify the respective parties. However, when I copy and paste it doesn't trigger, what do I need to…
-
Helper columns
Hi there, Is there a tutorial on helper columns? Helper columns have been suggested to me, and I'm sure they will help our group but I am still confused on how to use them. Thank you! Esperanza