I have a column with a drop down where you can select multiple options for one cell. It is tracking who is affected so it can list multiple departments. I want to track by department so I am trying to…
I am running a report from my sheet however the primary column shows up even though I did not select it and I cannot hide it. I don't want/need it in my report. I was wondering if there was a way to r…
Hello, I am looking for help utilizing a formula to hide the #DIVIDE BY ZERO error message. My current formula in the "Change" column is simple: =([Availability %]@row - [Previous Availability %]@row)…
I have a template that I created to use for several projects within my org. When I create a new sheet from this template my Duration and % complete columns completely break and do not work anymore. I …
Hi, I've spent way to long trying to figure out if Smartsheet can do what I want it to do so I thought I'd ask the experts. I have about 70 events a year and 150 tasks to complete for each event. It i…
Hello, I'm using a column to track what each row requires as a next step in the project. In some cases a row will need both say "requirement A" and "requirement B", therefore I'm using a multi-select …
I have made several workflows that were fairly large for different applications in smartsheet. I would like to have a simple function to print/pdf the workflows so as to see all of one at once. This w…
Hello, We are developing an outward-facing sheet that will be used by external clients. We need them to select Yes or No on a question provided. The issue we're having is related to the "send me a cop…
Hello, I am unsure why this formula is returning #UNPARSEABLE. =COUNTIFS({Task List - Texas Projects FND Prepare}, @cell = Name@row, OR(({Task List - Texas Projects Agent Status}, @cell = "Red"), ({Ta…
