Best Of
Re: Removing semicolon and pull multiple values from reference sheet
@Christina09 What @Adam Costello suggested would be the most accurate since you can do an exact match.
Otherwise you can make it work with Contains, but it's possible you may get erroneous matches if your item numbers get longer and contain the shorter number.
Formula:
=JOIN(COLLECT({Item Sheet | Item Name}, {Item Sheet | Item Number}, CONTAINS(@cell, [List of Item Numbers SemiColons]@row)), CHAR(10))
Screenshot:
@Michelle Choate 2 Thanks for the tag
Darren Mullen
Re: WorkApps Loading Error
Have you encountered this on mobile or desktop? I've never seen this, but if your workaround is opening a different browser, that kind of implies to me that the problem isn't Smartsheet but something with your browser settings. Especially if there's nothing on status.smartsheet.com when you encounter the issue, you may want to consider clearing your browser cache & history, and review your security settings to make sure there's nothing conflicting. Also, Smartsheet documentation says it only supports the two most recent software updates, so if you're running an older version of a browser or using something other than the main browsers available, you might need to make a few adjustments.
Good luck!
Kerry St. Thomas
Re: The Community Valentine's Day cards are back! π
These are so lovely! Happy Valentine's Day everyone :)
I'm so happy and proud to be part of this team π I'm sending love across rows and columns to my peers @Alison C. @Rebeca S. @Arsineh & @Maxwell Griffith , and definitely you are the champions of my heart @Genevieve P. @Georgie @Marcela π
And spreading the love to all of our spectacular community members, thank you for all what do you do to make this community a happy place. π€©
Isaac A.
Re: Using Attachments in Automation
Hello @kkinman. Unfortunately not at this time. It is either all or nothing.
Re: The Community Valentine's Day cards are back! π
I love these so much! Happy Valentine's Day everyone!
I'm sending @Genevieve P.,Β @Marcela,Β @Isaac A. the "Community Champions of my Heart" card, and I'm sending the "You make me feel like the Awesome Reaction" card toΒ @Maxwell Griffith, @Alison C., @Rebeca S.and Β @Arsineh.
There are lots of other people I would send cards to, but I'd be here all day, so I'll spare you all the tags!
But I will send out big love to all our Community members for all you do for each other and for making our Community such a great place to be! π
Georgie
Re: The Community Valentine's Day cards are back! π
@Julia L Rumburg - To my PeerConnect, Mentor and Friend, sending love across row and columns⦠and the Atlantic!
To the first person to show me kindness in the community when i first joined, @Paul McGuinness thank you, "You're Community Champion of My Heart"
To @Paul Newcome, "If you were a product idea, I'd vote for you"β¦ like is the AI feature even a real thing or is it just you at the other end of the text box? Thank you for all you do, for so many, all over the world.
Protonsponge
Re: The Community Valentine's Day cards are back! π
I would give you guys this one because you guys are constantly innovating and coming up with ways to make Smartsheet both a better user experience, and teaching others how to get the most out of the product.
Re: The Community Valentine's Day cards are back! π
This one goes out to our Community at large - you are each amazing and collectively make our Smartsheet Community, one of a kind! @Rebeca S. @Maxwell Griffith @Alison C. @Genevieve P. @Isaac A. @Marcela @Georgie you are awesome and I'm lucky to work with such such a dedicated and creative team.
Arsineh
Re: The Community Valentine's Day cards are back! π
@Alison C. @Rebeca S. @Genevieve P. @Arsineh @Georgie @Isaac A. @Maxwell Griffith Thank you all for being the Community Champions of my Heart! ππ You are the best team I could ever ask for and I deeply care for you!
Marcela
Re: The Community Valentine's Day cards are back! π
Oh my gosh, I will ABSOLUTELY be sharing the Product Idea card with my team!!
