-
#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…
-
Quick Form Toggle Accessibility from Sheet View
Capability to quickly access form from a sheet rather than clicking Forms, MANAGE FORMS, THEN OPEN FORM.
-
Smartsheet App - Sharing Workspaces and Sheets
When I share a sheet or workspace on the browser version of Smartsheet, I have the ability to check/uncheck notify people. I would like that same feature on the app. Currently there is no box to check or uncheck, it defaults to sending an email to the person I am sharing to. In my organization, we do not like to send…
-
Generate Document Text Customization
When generating documents, there is a preset text and text size. There are no options to customize. Often, the preset text does not match the text format on the document.
-
Merged: Date Format
This discussion has been merged.
-
Workaround to override column formula for dates?
Hi there, I have a sheet with 8,000 rows. In the sheet, each row has a task, task start date and task end date. When someone adds a start date to the first task, the rest of the dates are calculated with a formula, based on a lookup table that has values for how long each task takes. If I have 10 tasks, I want the formula…
-
Is there a Way to Emulate SUMPRODUCT In Smartsheet With a Cross Sheet Reference?
Hi all! I am trying to create a SUMPRODUCT in Smartsheet, however when I do I receive the "INVALID OPERATION" error. This is how I was trying to go about it; I created a helper column where I would multiply both A x B, then I was simply going to sum up all the products. The issue I'm encountering is with the first part. I…
-
Approval flow status - need help
Hello, I am in the process of creating a sheet (two separate forms depending on requesting line of business). My team handles one operation while my peer handles another. I have the automation when forms for specific lines of business it will send our respective teams an update will be sent via email. I also have a hidden…
-
How to Completely Remove PII in order to comply with GDPR?
Hi, I have a use case that is leading to some larger questions about how Smartsheet manages PII. In this application, we offer users a form to enter their information (name, address, email etc.) into a secure sheet for our limited use. This is all relatively easy, clean (and secure). However, it gets tricky to comply with…
-
Change Value in Symbol Column Based on Value of Other Column
Hello everyone! I have a Status column (Symbol type), where users can choose manually the desired status. I also have a Completed% column (Text/Number type), where a percentage is entered manually. I would like to change the value of the Status column to "Blue" when Completed% is "100%", but keep as is in all other…
