Best Of
Re: January Question of the Month - Join the conversation and receive a badge
Traveling to Tokyo has been on the buckt list for a really long time. One day - it'll happen!
Paula Grahame
Re: January Question of the Month - Join the conversation and receive a badge
Happy 2025!
Lots of big plans for this year, both personally and professionally.
One that I'm excited about is continuing to develop our homestead. We've already got chickens and are looking to begin building our garden area.
Sam_Harwart
Re: January Question of the Month - Join the conversation and receive a badge
Happy New Year Smartsheet Community. I have been using Smartsheet for 6 years and part of the community for almost a year.
One thing on my bucket list I haven't done yet is to travel to Europe. I want to take a 2-3 week trip and travel to Germany, Ireland and Italy. Explore my heritage and soak in the beautiful landscapes and architecture. I am hoping to do it for my 40th birthday.
BrookeGL33
Re: January Question of the Month - Join the conversation and receive a badge
Happy 2025, Smartsheet Community!
Making a list of things to achieve in the year 2025 seems to be the first item on the list
Nicolas Goulinet
Re: January Question of the Month - Join the conversation and receive a badge
I want to have dinner at one of those Michelin star restaurants where they experiment with food and food presentations.
Michael Drayton
Re: January Question of the Month - Join the conversation and receive a badge
Top of my bucket list is a visit to New York in December. My wife has a big birthday coming up soon so we plan on going there to celebrate.
John_Foster
Re: January Question of the Month - Join the conversation and receive a badge
Travel to Ireland and work remotely for a few months next summer.
Jayson Tyler
Now you can reorder items in your collection!
Hi Community,
Great news all, you can now reorder items in your collections for even easier management! Workspace administrators like you can organize your collections simply by dragging items up or down to better match the needs of your teams.
We will continue to make improvements to all things important to organizing and sharing work in Smartsheet. Stay tuned for some more exciting enhancements to this area coming soon! For more information, please read this.
You can also stay informed by Subscribe to receive product release updates for curated news of recently released product capabilities and enhancements for the platform of your choosing, delivered to your inbox. As new releases occur, you will receive a weekly email with news of what's released every Tuesday.
Thanks,
John Hieger
Product Marketing
John Hieger
Re: Formula not working on new sheet but same data
Never mind - I saw a similar post - you (Paul Newcome) had answered that question as well. I came up with
=IFERROR(INDEX({PERFECTION YARD CHECK TAG}, MATCH(VIN@row, {PERFECTION YARD CHECK VIN}, 0)), "")
and it works perfectly !
Davisc8
Re: Can I start my project codes from zero for the 2025 year?
Try this (assuming [UniqueID] is an auto-number column with no formatting):
=LEFT(Department@row, 3) + "-" + YEAR([Project Intake Date]@row) + "-" + IF(YEAR([Project Intake Date]@row = 2024, 100 + COUNTIFS(UniqueID:UniqueID, @cell <= UniqueID@row, Department:Department, @cell = Department@row, [Project Intake Date]:[Project Intake Date], IFERROR(YEAR(@cell), 0) = 2024), RIGHT("000" + COUNTIFS(uniqueID:UniqueID, @cell <= UniqueID@row, Department:Department, @cell = Department@row, [Project Intake Date]:[Project Intake Date], IFERROR(YEAR(@cell), 0) = IFERROR(YEAR([Project Intake Date]@row), -1)), 3))
Paul Newcome