-
Editable Approval Request
Is there a way to allow the approver to edit a field (column) in an approval request? As it stands now, it seems to only be "locked" or "grayed out."
-
Importing from Excel to Show Changes from Prior Import
I have an Excel spreadsheet that I need to import into Smartsheet. The Excel sheet is generated every couple weeks, which means some of the data may change from version to version. Once I create the initial Smartsheet sheet, is there a way to only re-import the data that's changed, or do I need to create a new Smartsheet…
-
Multiple approval workflows
Hi - I am trying to create 3 approval workflows. Each one as a sequence of approvers and some of those approvers are the same from workflow to workflow but for different approval purposes. I have been successful in setting up the first one, but when I set up subsequent ones leveraging the same columns/approvers, I get…
-
Looking for a more elegant way to send out multiple Update Requests at once.
Hey there! I'm a release manager and I'm building out runbooks in Smartsheet. If tasks are set to "In Progress" I want to be able to take an action (Check a box, picking a specific selection from a dropdown, etc..) so that an automated request will be sent out to the "Responsible Party" asking them to update their task.…
-
System Admins + User Sheets
Can system admins view sheets that haven't been shared with them?
-
Is it possible to create an account that would be a "view only" version of an existing account?
We know you can share individual "view only" records, and we do this with our suppliers. What we are interested in here is to have an separate internal account from within our company be able to see ALL records and results from an existing account but not be able to do any editing. Is this possible?
-
concatenating if statements
Hi Guys, First post and would really appreciate your help. I am trying to combine multiple if statements in one cell. I am not looking for AND / OR support but how I can return multiple values. IF([Bananas]2 = "x", [Bananas]1 + ", ", "") + IF([Apples]2= "x", [Apples]1 + ",","") When i run the first if statement it works…
-
Resource View Best Practices
I have built a Sheet that is planned to be used in our project planning and project delivery. One area I've been fighting wit a lot is Resource Management. The first being more a best practice when it comes to assigning resources. If I have a tasks called Design Workshops for instance, and I have a number of resources…
-
Creating a list of top clients
Hey, I'm having trouble currently : i'm trying to make a top 10 list of our best clients month by month, and i can use the functions Max and Large to get highest revenue among all clients, but how do i go fetch the name of the client associated with ? Is there a function that would allow me to get it automatically based on…
-
Creating an audit scorecard from a submitted form
Hello, I'm having a hard time creating a reusable audit scorecard from a form. Example: a person performing the audit would fill out the form questions. Each question has a choice of three dropdown responses of (Pass, Fail, Didn't evaluate). After submitting the form the user is redirected to a second smartsheet URL (the…
