Best Of
Re: How to export column properties with the column names
Currently there's not a formulaic way to get to the column name or properties to put that data into a cell. The API will give you this information if you want to use Bridge or another tool to read and write that info into your sheet, then export the sheet with that information.
Brian_Richardson
Re: Text to Date Field
Hi @John Stanik
Will your text entry always have the exact same format of mm/dd/yy?
You can use the DATE function to translate numbers into Dates, with the syntax being DATE(YYYY, MM, DD).
In this instance, we'll want to use the VALUE Function around each number set we're grabbing, like so:
DATE(VALUE(20 + YY), VALUE(MM), VALUE(DD))
Then we can use the RIGHT Function, MID Function, and LEFT Function to grab different elements of your text string.
DATE(VALUE(20 + RIGHT(YY)), VALUE(LEFT(MM)), VALUE(MID(DD)))
For the MID portion, we'll need to use a FIND Function to find the starting position (a number) of whatever it is looking for, in this case a "/". The formula uses the number it finds as a starting position in the text string.
Full Formula:
=DATE(VALUE(20 + RIGHT([Text Column]@row, 2)), VALUE(LEFT([Text Column]@row, 2)), VALUE(MID([Text Column]@row, FIND("/", [Text Column]@row) + 1, 2)))
You'll need to enter the formula into a Date Column. Let me know if this works and makes sense!
Cheers,
Genevieve
Genevieve P.
Re: ConnectWise Integration
Hi All,
Recently I've spoken with a few Smartsheet customers directly that need this, and I can see that there are a fair few of us discussing the need in this thread alone.
I've decided to get my Smartsheet integration team to build a CW connector. We're now taking enquiries so that we have a good understanding of customer requirements. Please contact solutions@infospark.com.au to have a chat with the team about your CW connector needs, and we'll have a connector available by early next year.
Cheers,
Lindsay
Re: March Question of the Month - Join the conversation and receive a badge
A skill I'd like to improve?
Learning to ask reflective questions as part of listening to & connecting with someone else.
Jennifer Kurtz
Re: March Question of the Month - Join the conversation and receive a badge
I have many skills that I would like to improve upon, but one skill that I would like to focus on and improve is my ability to write complex formulas in Smartsheet without having to rely on AI or others. I would also like to improve my ability to create robust solutions using Control Center.
Re: March Question of the Month - Join the conversation and receive a badge
Hello,
Shaffi Mithwani here from Nairobi - Kenya.
I would love to improve on my golf. Have been on and off the course for last 20 years and still don't have a handicap! Maybe I create a Smartsheet Dashboard to track my consistency, performance and nudge me to playπ
Shaffi Mithwani
Re: March Question of the Month - Join the conversation and receive a badge
One skill I'd like to improve is negotiation! Being verbally able to win my opponents. I think the linguistics behind the ability to do that always fascinates me!
If you're familiar with the show "Suits", you will understand what I mean :)
sdunham
Re: March Question of the Month - Join the conversation and receive a badge
Interpersonal skills- specifically, identifying how others best learn and function, and leveraging that to the fullest use of their skills to achieve an excellent work result that provides them fulfillment.
charleenL
Re: March Question of the Month - Join the conversation and receive a badge
I would love to improve my verbal communication skills.
amandacox
Re: March Question of the Month - Join the conversation and receive a badge
For me.. so many options, I think Id go with improving my overall mental and physical durability.
TimMelton