-
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…
-
Dropdown List, "Allow Multiple values per cell", provide an option to "Limit number of selections""
When working with a Dropdown List, it would be nice to be able to limit users to selecting X number if we have the "Allow multiple values per cell" option selected. Here is a concept art of what I'm imagining: Of course you could leave the value blank or have 0 be "unlimited". This could then transpose over to Smartsheet…
