-
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.
-
Notify SS users of past-due items with consolidated list of action items
What's the best process for notifying people on past-due items? We want to set up one email notification per action item/owner or one with a consolidated list of action items per owner. Would it be possible to group them into two sections in the email, one for past-due items and one for upcoming items within the next few…
