Best Of
Re: IF this, if this, if this, if not formula help
=IF([% Complete]@row = 1, "Complete", IF([% Complete]@row <= 0.99, IF([% Complete]@row >= 0.01, "In Progress", IF(Review@row = 1, "Review", "To Do"))))
Should just need to update your final FALSE IF statement with "To Do".
Jason Tarpinian
[GIVEAWAY] Jumpstart 2025 with Community!
Make some noise, Community! Are you excited for our Jumpstart 2025 party?
We’ve got double the reasons to celebrate, because the Smartsheet Community has reached its 10th Anniversary!! So, this is only the FIRST of many giveaways today. 🎉
In 5 words or less, what is your favorite accomplishment from 2024?
Answer the question and run back to the party, because we’ll announce the winners live at the end of the event. See you there! 🥳
Rebeca S.
Re: Calculating age between two dates issue
Give this a try:
=INT(((MONTH(COD@row) - MONTH(DOB@row)) + ((YEAR(COD@row) - YEAR(DOB@row)) * 12) - IF(DAY(DOB@row) > DAY(COD@row), 1, 0)) / 12) + "y " + MOD((MONTH(COD@row) - MONTH(DOB@row)) + ((YEAR(COD@row) - YEAR(DOB@row)) * 12) - IF(DAY(DOB@row) > DAY(COD@row), 1, 0), 12) + "m"
Paul Newcome
Re: Jumpstart 2025 is filling up quickly — request an invite!
Hi @melissalk,
I've contacted you via DM to help with your invite!
Rebeca S.
Re: Community Champion class inductions are underway! 🏆
Wow, I’m constantly amazed by how our Champions
@Jake Gustafson
go above and beyond to uplift this Community—and even more so to see that dedication radiate across social media, too (Reddit, LinkedIn, you name it!!!)! Their expertise, kindness, and positivity truly set the tone here and keep me feeling inspired every day. A big thank you to everyone who pours their time, passion, and support into making this space so welcoming!
And while there are so many wonderful people who’ve helped me out (and made my day brighter!) along the way, I want to give an extra-special shoutout to @Protonsponge. Thank you for being a guiding light in this Community!
Re: Introduce yourself & get to know your peers!
I'm Chris Joseph, Program Manager with OhioHealth, Born in SriLanka, but have lived in Asia, Europe and North America in the last 30+ yrs. Currently residing in Columbus OH and love the Ohio State Buckeyes. In addition my wife and I love to Travel and budding Foodie's. 3 kids (2 girls and a boy). Older 2 are out and freshman in HS. Looking to learn Smarthseets, become the Smartsheet Admin and gain my certification in Smartsheet Project Managment.
ChrisJ2025
Re: Introduce yourself & get to know your peers!
Hey folks, I'm happy to be here! I am a former Smartsheet employee who has just joined a team to help them with their Smartsheet implementation and build-out, among other things. I am beyond excited to be here and to dive back into the world of Smartsheet full time!
About me: I'm a Utah native who moved to Seattle 12 years ago (best decision ever!). I love music, and tech, and the combination of the two. I live 20 minutes north of the city with my wife, two kids, and two cats. During my time at Smartsheet, I was one of the resident SMEs for all things Resource Management. I'm hoping to flex those muscles once more through this community.
Emmett Tomkinson
Brandfolder Duplicate Detection Updates
Brandfolder is improving our duplicate detection user experience by providing clear notifications before duplicative files are deleted. If you have the Brandfolder setting "Don't allow duplicate files" enabled and you try to upload a file that's an exact copy of an existing file in your library, the system will automatically detect and block it. The duplicate file will appear with a special "File not processable" thumbnail. Clicking on the file will display a message explaining that it's a duplicate and will be automatically deleted after 10 minutes, with a link to the original file. This change aims to enhance transparency, reduce customer frustration, and minimize the number of support tickets related to duplicate files.
Environments availability: Brandfolder
Plan availability: All Plans
Thank you,
Haley Patrone
Senior Product Marketing Manager
Haley Patrone
Re: January Question of the Month - Join the conversation and receive a badge
I have always wanted to be head hunted… it seems like it would be such a nice way to find a new job. One where they want you so badly they seek you out and not the other way around.
Monicacraven
Re: January Question of the Month - Join the conversation and receive a badge
Travel
New Zealand
Alaska
Iceland
Gbur