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…
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?
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…
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.
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!
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…
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…
I am trying to figure out how to pull in the Name, County and Status from a master list onto a new sheet based on the master's Status column containing data. I am wanting to do this so that we are not overlooking anyone. I have been trying to figure it out and have seen that I probably need to use the INDEX and COLLECT…
I have a worksheet that I want to reference 5 reference sheets that contain staff members. Because of the large scale of staff members. We split them up by region. I want to create a column formula that will look up a "District ID" and return the "User" If they exist in one of the 5 reference sheets. This is my current…
Hello all, I'm having trouble nesting the IF(AND(NOT(ISBLANK formula. If the Provisional Requested Amount column is NOT Blank AND the Provisional Requested Amount is less than or equal to the Final Requested amount column, I want the cell to say approved... this is what I have. =IF(AND(NOT(ISBLANK([Provisional Requested…