-
Show data from columns that are not empty
Hello everyone I have a question about a use case and I don't know how to get the result I want in Smartsheet : I have a sheet with multiple columns (like 100 more or less) and in each column I can have some data or not. I need to have all these columns even if there are empty to store data. It is very complicated to read…
-
Ever invented or thought about how to use Smartsheet for the holiday season?
Hi, Im curious about what the community has built or dreamt of building for holiday season needs? templates for sending /automating holiday cards? gift list and shopping? menu/party planning? santa list etc? Im interested in ideas to spread some help and joy via smartsheet this pending season.
-
How do I easily move tasks and sub tasks at one time?
In TeamGantt you can easily grab the header task and slide it down on calendar (along with subtasks) wherever you need it to easily shift a schedule, however, it looks as though that isn't possible in SmartSheet. Is that correct, or is there a way to do this?
-
Resource View by Project
Hi I wonder if anyone might be able to shed some light on an issue I'm experiencing. I'm a new Smartsheet user so I could well be doing something wrong or expecting Smartsheet to work in a way that it doesn't. I'll set out the issue below and if anyone can explain what I'm doing wrong, or if there is a different way to do…
-
Departmental Ticketing System
I'm looking to merge several of our ticketing request forms into one form, such as maintenance requests, IT requests, and marketing requests. Based on the type of request, automation would be set to move those rows to another sheet for the admin to work out of rather than the original sheet with the request form. Has…
-
Form start timestamp
I've created a web form that will be heavily utilized. Managers are wanting to conduct a transactional analysis to see how long it takes the worker to complete. I'm looking for a way to capture the current time either when the form was accessed or find a shortcut to copy from the operating system and paste into the first…
-
Sheet links does not update automatically
Hi, I have one column of a sheet linked to one master sheet using Cell Linking. Just to add on to the information, the linked column in the master sheet is auto numbered and creates a unique ID of each row. The other columns in the linked sheet fetches the row information from the master sheet based on the INDEX(MATCH)…
-
Automate the creation of a entry in another sheet depending on a status of a cell in the source.
I have a grid that contains products which may or maynot need to be shipped to another region, I need to be able to list the products that require shipping and be able to view the status and update as needed. Example below, shows the region the product is for, the date required to ge on site, flag if it is suppose to be…
-
Current user report feature dashboard - external party use
Hi I am creating a generic Dashboard for our external partners and now need to add a reporting feature. The current user feature for reports works great for internal reporting but I am unable to share the source sheet or the report sheet with our external partners. I have searched the forums and google but i can't find a…
-
Printing a filtered view from a view-only smartsheet
I have our project schedule posted on a contractor dashboard as a view only document for all our contractors to view. I set it up as a view-only document so they can't mess with it. I've published filters so each contractor can see only their scheduled tasks. I learned today that when you try to print this filtered view,…
