-
How to change cell value from another sheet
Hello! Basically, I have an automation set up to send anything that is on Backorder (when B/O is checked) copy it from my "Open Orders" sheet to my "Backorder Clip" sheet. I have two questions regarding this. How do I set a formula that will apply any changes made to my "Backorder Clip" sheet rows will automatically update…
-
Introduction - Hello Smartsheet Community!
Hello everyone, I'm currently a student studying at Montana State University and I use Smartsheet to help stay on top of projects at work and at school. When not studying I like to get explore the outdoors with my wife and stare at bison (from a distance). Does anyone have any experience using Smartsheet with multiple…
-
How to get automatically an average data based on date rage on a daily basis
We are using form to create performane data per robot per run ( input can be few times a day) I need to start measuring daily avereage for their performance seperately (1 called North 1 called South) but can't figure out formula for it and then I'm assuming creating a chart would be straightforward? but not done it before…
-
Work Flow and Automation help
I am attempting to set up a workflow sheet between operations, sales, and owner. The idea would be to have master sheet where information is fed to it through multiple sources. Once the master sheet has all of the data needed it would then feed to sales and the owners to give them a snapshot of their work. Is it possible…
-
If all Child rows = "Complete" change Parent to "Complete" and send to new sheet
Hello! I have an automation that sends "Complete" Parent columns to a new sheet (my "Closed Orders" sheet). I also am setting up a formula for when all Children status' are set to "Complete" it automatically switches the Parent row to "Complete". What I am wanting to do is send ALL rows including Parent and its Children in…
-
Change Date column if new row is added after hours
Hello - We have a simple ticket system and if a ticket request from a form comes in after 4:00pm, we don't start the ticket until the next day. Case: Form Entry happens at 2:30pm on 07/27/23. Start Date column should read 07/27/23. Form Entry happens at 4:30pm on 07/27/23. Start Date column should read 07/28/23. So we want…
-
Working with an Outside Party
My question is when working with an outside party that will need access to my smartsheet, should I share my sheets or add him as a user on our company Smartsheet account? He will needaccess to see our automations,etc.
-
Form Automation - count option to select how many rows should be added
There should be a count option within a form to select how many rows should be added. I have a form that adds rows to a sheet with an auto-generating number system. It would be very nice to be able to select the rows within the form instead of using a backdoor with an extra "helper" sheet. My form will require the same…
-
Automation setting is NOT showing AM/PM in trigger
I have some users from the same Smartsheet account who informed that when they are trying to set up the recurring automation, there is no AM/PM to choose from. Not sure if only a few or all of them. Refer this image: When I try to do the same, I am able to do so (I am in different Smartsheet Account). Anyone encountered…
-
Visibility on Form Submission
Is there a way to increase visibility for requestors on their submitted requests? Like is it possible to send the requestors all of the requests they've submitted so they can see what they've requested, date, description, etc.
