-
Remove Primary Column From Report
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 remove or prevent it. Thanks!
-
How to hide #DIVIDE BY ZERO error message
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) / [Previous Availability %]@row But for any cells in the "Previous Availability %" column that have 0%, I get the #DIVIDE…
-
Column functionality breaks when copying sheet
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 have removed and recreated the columns to see if this will rectify the issue and it does not. No matter what I do I cannot…
-
How do I set up something in Smartsheet for Multiple Projects with the same tasks for each?
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 is just me working on this so I don't need to assign or escalate. I need to have reminders on certain tasks for different…
-
Automatically move rows within a single sheet
I pulled a template for a Team Productivity Hub (https://app.smartsheet.com/b/publish?EQBCT=f29e0f2c058f4563853d6497ce554bcc) from the solution center and the sheet for tasks had originally moved completed tasks to the "completed" hierarchy automatically, but now that i've made copies for my team and input some formulas…
-
Basic Formula
Two different equations are being used. Equation 1: =IFERROR((SUM([RN Section 1 Score]@row, [RN Section 2 Score]@row, [RN Section 3 Score]@row, [RN Section 4 Score]@row)) / SUM(IF([RN Section 1 Score]@row = "-", 0, 0.3), IF([RN Section 2 Score]@row = "-", 0, 0.3), IF([RN Section 3 Score]@row = "-", 0, 0.2), IF([RN Section…
-
CountIF for a multi-select drop-down
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 dropdown because it makes the most sense for me. In the sheet summary tab, I want to be able to count how many rows need…
-
Smartsheet Enhancement Request: Snapshot/Print Workflows
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 would help me with design, troubleshooting, and communicating the process to those involved in it. I have submitted an…
-
Is it possible to use the "request an approval" automation without "send me a copy of responses"?
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 copy of my responses" option at the bottom of the approval. The external clients are able to select that, and then receive an…
-
#UNPARSEABLE error in COUNTIF formula with OR function
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"), ({Task List - Texas Projects PM Status}, @cell = "Red"))) It is supposed to count the number of times a name in the "FND…