-
Searching function in dynamic view
Hello- I really need a search function in dynamic view or I need a way to have interactive reports without granting people access to the underlying sheet. I don't understand how anyone can use dynamic view that has more than a page worth of data. Nobody has time to create filters everytime they need to look at something.
-
Auto updating form field dropdown menu based on entry submissions
I am trying to create a form that gives users dates and times from a dropdown list to sign up for coaching sessions in a way that when one person has selected a given date and time it doesn't allow another person to select that time and disables/eliminates it as an option from the form field dropdown menu. Is this possible…
-
How to make child rows indent in a report that rolls up multiple plans?
Hi, I need to roll up detailed plans across multiple sheets, and have the parent child relationships be really clear by having child rows indented, just as they are in the original plan. Is there a way to make sure that child rows indent under their respective parents in a report? Thanks! Brent
-
Help to create a "3 Dimensional Reference" Formula
I am trying to create a sum of the same cell in four different Metrics Sheets. I have created the following formula and I get the Unparseable error. Would appreciate help, please.
-
Using DataMesh to Split One Line Onto Multiple Lines (for Forms Entries and Other Uses)
This is a problem I've heard a few times so I'm answering it in a separate post for reference in long form. I'm using the example from @WtaylorW's question over here. The basic need is to take one line and split it onto multiple lines. In this example you have a form that's inputting multiple names in different columns,…
-
Reorder Favorites and Pinned Recents
It would be helpful if you could drag favorites and pinned recents to customize the order they appear in.
-
Smartsheet integration with Docusign
I integrated Smartsheet with DocuSign in 2023. I made a minor change to the DocuSign document and updated the email addresses so that notifications are sent to me instead of the finance team. After making these updates, I encountered a challenge with the group email address. Smartsheet is not sending emails to the list,…
-
Duplicate a Datamesh
My team depends on a series of "working" sheets (target sheets) that have a set of predetermined columns that all populate data from a central "data" sheet (source sheet). The data sheet stays static, but the working sheets are frequently added. The ability to duplicate a datamesh and simply change the target sheet would…
-
Auto fill date and time emailing the wrong information?
Greetings, I set up a very simple form pictured below where someone could select their name from a drop-down and hit submit. On the back end, I have a column called date which enters the date and time of the submission. This information is then emailed to myself and a manager with all of the information in the row. When I…
-
Two-way street for updates between two sheets
I have two sheets used by different people. Management uses one and developers use another. Basic data being tracked is the same between the two but the one the developers manage contains technical information that management doesn't want. I run an automation so when new lines are added to the technical tracker are added…