-
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,…
-
Workflow Question
I am trying to automate the distribution of safety inspections to our company. At the moment someone has to select a new line and send the alert email to specific groups for their attention. I was hoping to automate this process using a workflow where when a new inspection is recieved from a user form it is automatically…
-
Trigger workflow
Hi there, I wanted to create if a field is updated/changed and a certain field is blank that it sends an alert. However, I want that to be daily just in case I forget. The workflow trigger, if I set it to daily is that how it will work? Thank you for your help in advance! Iris
-
Is it possible to have a Report always query all grids within a folder?
For ease of workflow, I use "Closed" / "Active" folder structures for my projects, to keep organization/navigation simple and relevant to active projects. Currently, when building a report, you can click a folder to include all grids within the folder. It would be great if the report could retain the folder selection,…
-
Time update schedule
Never work the time update email schedule. For example send update request every day at 4 PM. Can you pls help me?