Can someone assist me with creating a formula that will automatically change the status to open/in progress when a RAID item is added and save to the sheet?
Hi, I have created a logic step where if the form user fills out yes to a question, two extra rows appear. I have tested the form and it works but the additional information appears in the back-end sheet as extra columns. Is it possible for the info to be separated into two different rows rather? We would like the basic…
Here's what we would like to accomplish: Assign multiple Users to a single column/cell (Bob, Sam, Ed...) Kickoff an Automation to 'Request an Approval' for all Users in Step # 1 Email request to all Users Approve from Step # 2 Confirmation all Users have approved from Step # 3 Only once all Users have approved from Step #…
Hello Lovely Smartsheet Community! Hoping you can help :) I am working on a deployment project where there are two different eligible vendors, and any of the 7500 clients may switch vendors at any time. Therefore, there are 4 options in my "Vendor" dropdown column: Vendor A Vendor B Ineligible Vendor No Vendor I am trying…
I want to set up an automation to copy rows from sheet 1 to sheet 2 when a condition is met. Is it possible to have comments that are added on sheet 2 also populate on sheet 1? Basically I want to see any comments added after the row moves on both sheets. Thanks in advance for any advice to solve for this!
Can a report be directly exported from a WorkApp?
I have 1 sheet and several reports, but my latest report I've shared with several people, and they do not see the data. I've changed their rights, moved out of workspace, moved the sheet out of the workspace. Shared with link and just email invite. Nothing seems to change the fact that they cannot see the data in the…
Hi there- I'm currently deciding on what would be the best approach for helping my organization keep track of our projects so that the data remains clean and it's easy to capture on dashboards. I know you can create multiple sheets and have it feed into one master sheet and that you have the option to use one sheet to…
I need help with update requests: I use automations which include cell values when {{task name}} are used but I can't figure out how to include the cell value in an Update Request. For example: Please click the blue button and update this form with the leased FTE for {{Provider First}} {{Provider Last}} at xxxx. Please…
Good morning! I have a sheet that I am working on for voting on tool enhancement request. I currently have the sheet set up to request voting on 6 categories for a purposed update for our tool. The issue im running into is the update request is being sent to multiple contacts (for test purposes we are using 6 contacts),…
Hi there, I am hoping to find a way for our staff who submit information through form to receive an email confirmation without having to get a copy of the information they fill in the form. At the moment the only email option is to have them get a copy of their response to the form, but I don't want them to have a copy of…
How would one go about getting access to a sheet/form if the person that created it is no longer employed?
How can I customise an update request in a workflow, so that the updater has fields that are required to be updated before submitted the update?
Help shape the future of Smartsheet. Share your ideas and feature requests.