I am trying to create an automation event that copies a row from my Order Tracker to my Shipping Tracker but none of my sheets are coming up for me to select where to copy to. At first I thought that it was because my Logistics Manager created the Shipping Tracker but I have edit permissions for that and also, none of my…
When you work with workflows and customized messages in workflows, the automation will generate separate notifications if six or fewer rows are triggered simultaneously. If seven or more rows are triggered at once, the system removes the custom subject and message body -> this merged notification results in the user…
Currently when creating an alert automation you have the option to include Message Only, Link to Sheet and All Fields, or Link to Sheet and Specific Fields. We are trying to promote WorkApps instead of users accessing the source sheet, so it would be better if we had two additional options: Specific Fields with no Link…
I would like to have a sheet with all of my part numbers and the various information that pertains to each part number on it. I would then like to have some sort of sheet or report that has a dropdown for me to select the part number I am looking for, then it will populate all of the information for that part but in the…
This discussion has been merged.
Hi, I was wondering if there was a way to automate a report that could be emailed for all users who haven't logged into Smartsheets in an "x" amount of time. So for example, a report would run monthly and email me all users who last logged in over 3 months. Any information is greatly appreciated.
I have each assigned to person with conditional format with a color to let them know what they are assigned to work, but what if i need two or more associates to work that particular assignment, how do i set up conditional formatting for that, or would that be a formula?
Hi, Is there a way we can lock certain rows of the parent row column so that no one can edit it? However, the child rows would not be affected by it. Thank you for your help!
I have a few automated reports that go out every Monday. Is there a way to have this report (PDF or Excel) include the documents that are attached?
I currently work in a lab that is looking to up their game on inventory management. We have an inventory smartsheet that gets updated after technicians manually check inventory in lab and update the sheet. Naturally, reagents get missed and our smartsheet becomes inaccurate very quickly. I'm trying to figure out a way to…