Best Of
Re: March Question of the Month - Join the conversation and receive a badge
What's one skill that you would like to improve? (Work-related or not.)?
I would like to improve my listening with intent. The benefit to this is it can help you improve your relationships, understand conflict resolution, and grow as a communicator.
Jen Lawson
Re: March Question of the Month - Join the conversation and receive a badge
One career skill that I would really like to improve is effective change management. I find that change management tends to be one of the more difficult pieces of successfully executing a Smartsheet solution implementation.
SDURKEE_01
Re: March Question of the Month - Join the conversation and receive a badge
I would like to improve my use of Smartsheet Dashboards on the work side. On the home side, I would like to improve my turn time in my Resell business.
JoHanna_Schultz
Re: March Question of the Month - Join the conversation and receive a badge
The skill I would like to improve is my selling skills, selling a great idea to executives, better at selling what my accomplishments are, etc…..
Re: March Question of the Month - Join the conversation and receive a badge
I have been reading the coaching Habit and learning to say less, ask more and change the way I lead.
Re: March Question of the Month - Join the conversation and receive a badge
One skill I'd like to improve in relation to health and Crohn's disease would be a deeper understanding of how diet and nutrition impact the disease. While I know that Crohn's disease is an inflammatory bowel condition, I would love to learn more about which specific foods and nutrients can help manage symptoms or even reduce flare-ups. There’s a lot of research out there, and understanding the nuanced relationship between food, the microbiome, and immune response in Crohn's could be incredibly helpful for those managing the condition.
AngB789
Re: March Question of the Month - Join the conversation and receive a badge
Hi community,
many skills could be improved but on the Smartsheet side I currently would pick WorkApps sourced by SCC. Working on that ;-)
On the personal side I'd love to improve my quick-wittedness similar to the what you see in the film "Amélie" ;-)
Stefan
Re: Happy 10th Anniversary Community + Giveaway!
Smartsheet is a web-based work management platform that lets me organize, automate, and visually communicate the work of my team.
:)
And is also my favorite tool ever!
Jennifer Kurtz
Re: Trouble with IF statement and date format conversion
Happy to help. 👍️
That formula in your last comment is accounting for moving from December to January using the IFERROR.
=IFERROR(DATE(yyyy, mm + 1, 1), DATE(yyyy, 1, 1))
Paul Newcome
Re: How do I write a formula to use multiple columns in a single cross-sheet reference.
Depending on what you are trying to pull off, this may be straightforward or may be an absolute nightmare. Certainly you can make a cross sheet reference to more than one column - figuring out how to use it in a formula is a bit trickier. With no direct equivalent to the "offset()" function in excel, the two methods I've seen used are vlookup() and index({inputRange},match(),match()) with the input range being multiple columns in a single reference. Both have weaknesses and ways they can go wrong, but are paths that might work for you. More specific advice would require more specific levels of details.
Jgorsich