-
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…
-
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…
-
Access to a confidential sheet
Hello, If I have a Sheet that I want to keep confidential from everyone else, is there anything else I should do to protect it, besides making sure it isn't shared with anyone else? Thanks, Karen
-
CTRL + ] Does Not Indent, But Right Clicking Does
Our Senior VP is having an issue with a sheet where she is unable to indent a row to be a child/sub-task. The strange thing is she is able to right click and indent it, but not using the keyboard shortcut. The keys are working just fine (able to CTRL + C/V, and the [ and ] keys all work individually) but it does not allow…
-
Help getting the summary of my sheet
I am not getting the result I need from a formula I am using. I am trying to track how many audits are completed and how many are left to do in total for this quarter '__ of ___ done', currently I am using this formula: =COUNTIF(CHILDREN(Done2:Done130), 1) + " of " + COUNT(CHILDREN([Task Name]2:[Task Name]130)) + "" + "…
-
Collecting Average Between 2 Ranges
Hi all! I am trying to collect an average over the last 12 rows (including the current row). To do this, I created 2 additional helper columns (Line-ID and Row#), and trying enclosing the condition in an AND clause, however this seems to return unparseable. I think I am on the right path or way of thinking here, but that…
-
Is there a way around an Invalid Operation when using Dates generated by formulas
Hi, I am trying to use this formula =IF([Next inspection due]@row <= TODAY(0), 1, 0) then mark it with a flag. in the Flag Due Date column. Every time I use this formula I get INVALID OPERATION because the Next inspection due column is created from a formula of a formula of a date. Date6 is add on 6 months, Date1 is add on…
-
Gantt View on a Dashboard - issues with Gantt showing data accurately.
When using a Report to pull data from a Sheet, the report allows you to configure the Gannt in various was (day/week/quarter, etc). When displaying the Report on the DB, and wanting to view a part of the Data, and the Gantt at the same the ---> the Gantt isn't proper. Ou use-case is shipping goods measuring Pickup Date to…
-
Customization of Default Phrases in various areas
For vaious methods of communication, Smartsheet has default pre-populated messages: SEND, SEND UPDATE REQUEST, and others. Is there a way for us to customize these pre-populated messages - highlighted on the screenshot (and any other pre-populated verbiage)? So they are automatically pre-populated with our message?
-
Trigger "when rows are added or changed" doesn't work
Hello all, I have created a Workflow to send a weekly email notification when rows are added or changed in a Sheet, but it doesn't work with "Run Now". It doesn't detect any of the changes made. I have created this Workflow on other Workspaces and it works fine. If you have any idea, why in this case it is not working, do…