-
Trigger Issue
For one of my sheets, when someone submits a request through a form, I have some rules that assign approvers, and also some rules that assign the number of approvers. These always work fine. Okay, as one example, let’s suppose the number of approvers is just one. I have a Change Status rule like this: When rows are added…
-
Admins cannot Edit our Smartsheet after sharing permissions changed
We are on a Pro Plan account with one license. We would like two people to have the ability to edit and add data to a Smart Sheet. We have granted them editing permissions and then tried giving them Admin permissions. They are both unable to edit or input any data in the smart sheet. The two people we wish to give System…
-
I need to string together many conditions
I have 8 conditions I need to string together, if all are met the formula should return "yes" if anything any condition is false, the formula should return "". I have tried nesting If/ and statements a number of ways, but since they all need to work together I am coming up #unparsable with each iteration. =IF(AND([Contract…
-
Auto-populating sub-tasks from Form.
Hello. I have a list of tasks, assigned to different people, that have to happen each time a new topic comes up. Ideally, when a user submits those topics via a Form, I would like that list of tasks/assignees to auto-populate as sub-tasks below row of information that was submitted from the form. Is that a thing that can…
-
Is anyone else experiencing "An unexpected error?"
I am getting an error for most of my reports reading, "An unexpected error has occurred running your report and the Smartsheet.com team has been notified." Is anyone else seeing this?
-
Using smartsheet-python-sdk to put data back into Smartsheet
I used the smartsheet-python-sdk (and unique API key from Smartsheet) to automatically pull data from Smartsheet into my Python script along with other data sources to create new feature-engineered columns. Is there an automatic way to now put these new columns I created back into the same Smartsheet I initially pulled…
-
Adding one word in front of selections in multi-select dropdown column
Anyone know of a formula that would do what I've manually done in the screenshot below? I'm trying to add one word in front of each multi-select option selected and put into a new column.
-
Reset a Row
Hello, I am looking for a way to have certain cells in a row "reset" once a checkbox (in that same row) is checked. When I say "reset", I want two cells to go back to being empty and another cell to have an updated quantity. Is there a way to do this? Maybe multiple automations? Appreciate any help or ideas!
-
How can I regain access to a sheet with errorCode 48?
I lost access to this sheet yesterday morning while using it, as did everyone who the sheet was shared with. How can I regain access to the sheet? I submitted a ticket yesterday and haven't heard anything back on it yet. I've logged in from a different browser. I've logged out and then re-logged back in. I even tried…
-
Pie Charts bug? Every series is an [unnamed series]?
Why is this pie chart broken? What is [unnamed series]? It should be "Executive Team" and "Vertical Construction" as the series. This bug has existed since 2018 and it there doesn't seem to be any solutions. Graphing from a grouped report- 'Unnamed series" in legend What's with the "unnamed series" in the pie chart? How do…
