-
Combining rows with like names
We have a sheet set up with forms to allow for participants of a contest to #1 register for the contest, then #2 go to the second form to update their progress in the contest. Is there a way to combine rows when a someone submits the same name or email address, for easier tracking? Something that is automated to create…
-
First time at ENGAGE 2022 and loving it!
This is my second here at #Engage2022 in Seattle, WA. and I feel amazing! What an wonderful experience to be attending to. I really happy to be surrounded by a diverse and enthusiastic group of peers, this is a great example of how in-person events were something that we were all missing. Sharing insights, knowledge,…
-
Gennevieve at Communinty
Gennevieve at the Community booth absolutely crushed it. She was able to show me around to some cool spots and gave me some insider tips!
-
Stumped on an IF formula
I have data in the following fields: Target Sales: Last Week's Sales: I currently have a formula that tells me if Last Week's Sales are less than Target Sales, then return "Yes" or "No" I need to update the formula to tell me if Last Week's Sales are less than Target Sales, are Last Week's Sales below more than 5% of the…
-
It’s so awesome to participate live in Engage!
Words can’t describe how great it is to meet all the Smarsheet people live finally after 3 years on working with Smarsheet from Europe. Everything is so tip top organized here. Positive energy on every corner. People are so friendly and devoted what makes this event very professional. Happy & lucky to be here. @Alison…
-
Using Power Automate Flow to add new row
Hi Community, I am creating a power flow that creates rows in SS based on an email. Everything works fine until I want to add data in a contact list column. I have tried different formats without luck: only email only name First name, last name, email { email: emailAddress, name: name} I get the following error The value…
-
Is there a way to create a 'collapse section' on a Dashboard?
I'd like to truncate the Dashboard view for my users so that they can select what they want to see by Section Content (eg Project Progress, Project Resource Links, News/Updates etc.), instead of everything being available as a huge data dump a mile long. Is there a functionality to expand/collapse sections on dashboards…
-
Linking an Excel cell to Smartsheet a cell
Dears, I would like to collect status updates from test scripts created and used in Excel and present it in Smartsheet. All test scripts in Excel have one cell indicating the percentage completion level of the test script. Objective is to link that one cell to Smartsheet sheet where I present the list of all test scripts…
-
Pinpoint locations to a map
Is there any way to extract an address from a sheet and pin it to a map? I would want to pin several locations to the same map if possible. I was thinking maybe somehow do this in a dashboard?? Thank you, Cheryl
-
Dashboard Line Chart - Automatically Update
I have a Dashboard created with a Line Chart in place that plots simple data points 'as of' a certain date. I have a Data Shuttle that updates the source sheet each Friday with a new data point. Is there a way to get the Line Chart to automatically recognize that a new row / data point was added to the source sheet?…
