Best Of
Re: Introduce yourself & get to know your peers!
Want to meet more amazing Community members? Here are a few for you to check out! π
@Laura Murdock, is a Sr Marketing PM who uses Smartsheet for everything, and enjoys yoga and reading mountaineering history books. Learn more here.
@Ray Lindstrom supports several teams by providing solutions from Project and Portfolio Management to training. He also loves fishing! Learn more here.
@Stefan has been working with Smartsheet for 10 years in different roles. One of his favorite activities is Dragon boat paddeling. Learn more here.
@Natalia is a project manager and uses Smartsheet to track projects and information. She's a Smartsheet Automagician in the top 5% of automation users. Learn more here.
@Christian Graf is a controls and Automation Engineer. He enjoys hiking, fishing and and lurking in the unanswered questions forum for formula related questions. Learn more here.
@rshelnutt is an Accreditation Specialist at a multi-hospital system. She completed her Core badge and is now preparing for the Core Product Certification exam. Learn more here.
They are awesome, right? Discover even more introductions at Show & Tell!
Rebeca S.
Replacing all special characters in form query string parameters with a formula
Hello everyone!
I am excited to be speaking at the "Leveraging the Query String in Forms" session at Engage 23!
I wanted to share a formula that a customer and I developed to replace any special characters that could show up in cell when you are building a URL to a form with query string parameters using a formula. This would typically be used if you were trying to pass a free text cell such as notes or description to a form.
A unique part of this solution is that if = or & show up in a cell that you are referencing for the value of a query string parameter, you would be replacing those values with the encoded value in values, but those values are also needed to properly format the string. I have used || to represent the & character and |^ to represent the = in the formula, the properly replacing them with SUBSTITUTE after any & or = have been replaced.
="<form URL>?" + SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(<query string formula>, "%", "%25"), " ", "%20"), "#", "%23"), "$", "%24"), "&", "%26"), "||", "&"), "=", "%3D"), "|^", "="), ":", "%3A"), "<", "%3C"), ">", "%3E"), "[", "%5B"), "]", "%5D"), "{", "%7B"), "}", "%7D"), "+", "%2B"), "@", "%40"), "/", "%2F"), ";", "%3B"), "?", "%3F"), "|", "%7C"), "~", "%7E"), "'", "%27"), ",", "%2C"), CHAR(10), "")
<form URL> would be the URL of the form itself. Like https://app.smartsheet.com/b/form/1a2dsfs8343
<query string formula> would be something like βProject Number|^β + [Project Number]@row + β||Project Name=β + [Project Name]@row
I hope to see many of you at Engage this year!
Chad
C Eiring
Re: Conditional Formatting on Sheet and Row Level
I have 16 columns of data and I have to set 5 rules for each column. This causes me to have to create 80 rules which was time consuming
Sam L
Re: Calling all Music Fans - Let's make a playlist for ENGAGE ο»Ώο»Ώπ§οΈβ¨ο»Ώο»Ώ
Hi all! This is a super fun thread. I love sharing music and making playlists :)
I saw an opportunity to use Smartsheet itself to submit, upvote and organize these song submission - build a playlist in style - so I went ahead and repurposed a submission / upvote structure I already had assembled and configured it for a dang dance party!
Feel free to head to the published dashboard and check it out. You can submit, then upvote, your favorite songs. I only caught up submissions in this thread through Michelle Basson to get data flowing and formatted. I also included "Pearls" by Jessie Ware as a personal pick. That song really makes me move.
Does anyone know if it's possible to embed a Spotify playlist in a dashboard? It wasn't among the list of enabled content.
This was a fun exercise but took a bit longer than expected - heading to sleep now. If this dashboard feels like a fun resource for the thread / effort, I can tune it up to include a "Moderator" request feature, where you basically submit to gain Admin permissions to the underlying workspace. I'm happy for folks to throw down and improve this structure.
Kyle Chipman
Collaborative and real-time editing
If multiple users end up editing the same cell without realizing, the last change that was saved overwrites the other. All editors should be able to view the current cell that is being edited and should be able to lock them as they continue to edit.
Deepak
Re: Dark Mode for Desktop App
I feel it would be great to have SS in a dark mode, daily I have all other apps are running in dark mode on tablet and CPU, but then I switch to work in SS and BAM! The brightness...its too much :). Please add dark mode as a default option.
Ash SS user 101
Re: August Question of the Month π Join the conversation and receive a badge!
No brainer, Smartsheet community is the first place to look for advice whenever I am stuck. This literally has answers to anything and everything. The community questions and answers can in fact be turned into an AI based knowledgebase. SmartsheetGPT perhaps?
I have always admired how my colleagues @Kaveri Vipat, @Anjanesh Vaidya, Nisha Goutam and @Shubham come to the rescue when I need immediate support.
Amit Wadhwani
Re: August Question of the Month π Join the conversation and receive a badge!
I am the go to person at my company regarding Smartsheet. If I need with a formula, I will go to the to the Formula Book first (IU love that thing!!!!). But sometimes I require a better explanation, or because my problem is complex. That is when I make a beeline to the Smartsheet Community. Answers are posted fast by people who have quickly become among my friends. I feel I literally know many of the Smartsheet Community people as we spend so much time together. I will also spend time at Smartsheet University. I lover Smartsheet, and before I had this job, I never used it. My boss got me an Admin license and had me creating almost immediately!!!!!
Sherry Fox
Re: August Question of the Month π Join the conversation and receive a badge!
I always turn to the Community for any problems I encounter. And someone always has the "fix" I need to straighten out the problem!
Kitty
Re: August Question of the Month π Join the conversation and receive a badge!
I have a couple of coworkers I refer to as my Rubber Ducky. When I get stuck, I walk through the issue, and because they are listening I tend to solve the problem myself. But beyond that - it's the Community!! I love interacting with this group of SmartNerds!! π
Darla Brown