-
I created the Coronavirus Preparedness Template Set. How can we improve it for you?
Hey everyone! I am a Product Marketing Manager at Smartsheet who helped create the Coronavirus Preparedness Template Set available on Solution Center. It’s exciting to read the feedback you’ve submitted and scroll through LinkedIn to hear how many of you are using it. A lot of organizations are taking advantage of it! We…
-
Volunteer Allocation
Hi All, I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific locations (we do not know these specific locations until last minute). I have built a survey…
-
Cannot transfer ownership of Smartsheet Calendar
I am trying to transfer ownership of a Smartsheet Calendar to a coworker, but when I try, it is giving me an error message, saying that the user isn't found and new user needs to be shared to the source sheet/report as an Admin in Smartsheet. I have checked, and this coworker is already an admin in all of the source…
-
How do I set an automation without a trigger or is there a workaround to create a trigger
Hello! I am needing to set an automation to lock and unlock rows. I have the automation set to lock the row when it is changed from “open” to any other value. I need a time based function that will allow the cell to unlock a certain time period after it is locked by the first automation. Essentially I want to ensure that…
-
Is there a way to show the report and give edit access to add comments and add attachments?
I have designed a workflow for our team and used the Request system workflow as a start. I created a report and attached the link in the email when someone submits the form. I have this report linked with the underlined sheet where my entire team works. V have information that shouldn't be shared with anyone outside the…
-
Problem with 'workday' formula
I can't seem to get the following formula to work in my smartsheet - it is referencing a column with dates in it: =Workday([Due Date]76,5) What am I doing wrong? When I type it in, it just treats the syntax as text. Thanks!
-
How to re check many attachment file? When I backup data from Smartsheet.
Hi, When I do backup of my Smartsheets, all of my files that were attached to any rows are saved to a separate folder. That's fine, but my problem is, I don't know which rows those files were attached to. I need to find a way of linking files to the original rows that the files were attached to. please help me.
-
Using Smart Sheet and Web Form to manage testing
Hi, Are there any recommendations you can provide to using Smart Sheet and Web Form as workaround to traditional testing applications to manage repetitive testing (case management and result gathering) across multiple users performing same test case? I'm currently using a reporting template but there are numerous…
-
Engage Track Sneak Peek: How Smartsheet uses Smartsheet
I have the honor of partnering with a number of colleagues from across the organization to bring you the "How Smartsheet uses Smartsheet" track as part of our annual Engage Conference this year! Real use cases provide so much inspiration and practical advice. How are YOU successfully using Smartsheet to drive work forward…
-
Updating Date Column if Another Column has been Changed
I am trying to create a formula to change a Date column to update to the current date when another column has been changed. I have used the TODAY function within IF but this updates the current date every time the sheet is opened and saved. I only want the Date cell to change when a specific other cell is changed.…
