Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Hi, i need to join 2 columns. First column is the City Name and second is the Numbers. I got it to work but I only need the first 3 digits from the City : =JOIN(City1 + Number1) comes out CITYNAME3462
I need to show up CIT3462
thank you for the help
Try
=Left(City1, 3) + Number1
OR if your join actually worked, you can also try this...
=Join(Left(City1, 3) + Number1)
Thank you very much!
I'm trying to update a workspace logo with a 77 KB PNG file, but the logo isn't changing. I've already logged out and back in, and checked multiple times.
When using automation to request for update, how can I know when the form was updated? One way is to compare timestamps, but Smartsheet only have the default Modified timestamp and Automation Record Date only captures the Date value.
I have a smartsheet that trackes each time an employees offers to lead a tour. The sheet captures the guides email, the tour date & time and # of guests that attended. We are looking to incentivise the tour guides and offer a reward when they reach given markers. After their 4th tour they recieve a $10 Food voucher. After…
