Best Of
Re: Introduce yourself & get to know your peers!
Hiya! I'm Genevieve on the Smartsheet Community Team - I'm from Canada but I live in England.
I love getting creative in Smartsheet for non-work related things.... during lockdown in 2020 I created a Battleship game (with two linked sheets) as well as a version of Codenames to play with friends over zoom.
Keep your eyes peeled for some fun games our team has come up with this September for Engage!
You can learn more about me in my "Meet Genevieve" post here, or in the July 2023 Community Corner Newsletter, here!
Genevieve P.
Re: From email name for Smartsheet automations: select a generic value versus owner
We have gotten feedback that across departments people think automated emails from Smartsheet are an advertisement, and they go ignored. This is more common if they aren't familiar the name of the sender. A person who creates a sheet for automated alerts is not always the person who makes the most sense to have their name as the sender.
Solution: Sheet owner can plug in their org details to create an Alias that fills the spot. (Department) at (Company) via Smartsheet. If the tag "via Smartsheet" isn't a required piece, allow for this to be removed - I assume this isn't an advertising method because they are most always being directed to access a sheet in these automations.
This solution could also extend to Sheet Admins. A sheet admin is likely to be a liason or an internal person who submitted a request to have the sheet made. Transferring ownership of the sheet to them is not viable in a lot of instances. Simply allowing the Sheet Owner to send an access request to the Sheet Admin would allow for this versatility.
Lastly, automation@app.smartsheet should be included in this, because an alias of CompanyName@app.smartsheet or DepartmentAbbreviation.CompanyAbbreviation@app.smartsheet would immediately give credibility upon glancing at the email address. It quickly clarifies that someone is using the service Smartsheet within the organization.
srasbornik
Re: π¨ New Community Topic: Community Job Board
We are hiring for several key finance positions. Smartsheet is fairly new to our company so I would absolutely love a few more Smartsheet enthusiasts with me! Our main location is the Nashville, TN area but you can always filter by state to see what is available in your area if you can't relocate. FYI - they won't have Smartsheet on the job description. Just know - we use it!! :D
https://loewshotels.wd5.myworkdayjobs.com/en-US/loewshotels/jobs
Darla Brown
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