-
Dynamic view @mentions - email not to take the user to the underlying sheet
the email notification to the @mention take them back to the underlying sheet, this defeats the purpose of keeping the user out of the base sheet. When the end user get the email notification, it should take them back to the dynamic view to add the comment.
-
How to Filter on Blank Cells in a Multi-select Contact List Column
We have a ticketing system that has an assigned column that is a multi-select contact list column type. Before I switched it to multi-select I had a filter that showed the current user and any rows where the assigned column is blank. When I switched to multi-select the blank filter stopped working. I tried a helper column…
-
Combine Contacts from multiple columns into a single cell
Allowing contact columns to be combined into a multi-select contact column would make team management and index sheets much more useful. If Columns 2 through 10 on my sheet are all contact columns, a formula like =Contact2@row + Contact3@row + Contact6@row should produce a multicontact cell, not a text cell. That would…
-
DataMesh Note Section
Within DataMesh it would be really helpful to include an additional field to provide a description of what workspace/purpose etc. that the DataMesh config is applicable to. Currently I have ~50 configs for various workspaces. I have come up with a naming structure however I am limited to how much space I can use.
-
Merged: Enable Card View for Reports within WorkApps
This discussion has been merged.
-
Automation for notifications only partially working
Hello all, I have an automation on a sheet that runs when a value is placed in a field to notify individuals on the team of said information in the field. For some reason however, the automation runs and only sends the email to one of the recipients not all listed in the automation. For example, the email recipients…
-
If the checkbox is checked copy the row
I am having issues solving a problem. I have a sheet containing multiple columns (3 text/number, 1 date, 1 contact list, and 1 checkbox). Made out of around 150 rows. I want the rows copied to another sheet if the checkbox is checked. I tried: Using a copy row automation which works but rows are always copied at the end of…
-
Board View Report Without Giving Users Access to Sheet
We have a Smartsheet form where users can request a certificate of insurance. Their email address is recorded in a contact field. I've created a report that filters the contact field to the current user. We'd like for them to be able to see the report in board view, but only for their requests, and do not want to give them…
-
Parent/child rows in a report even if not assigned to parent row
I need to build out a report that pulls the below information: Report needs to show the parent and child rows -Parent is not assigned but child is assigned -Parent is assigned and child is assigned I am open to helper columns but everything I have tired is not working. Formulas: -Parent Helper: =COUNT(ANCESTORS())…
-
Can we auto create the Row Link as a Hyperlink to autoconnect to that row yet?
Please tell me this is available. It would be nice to be able to create a column on a sheet that will automatically create a hyperlink to that particular row!!!