Best Of
Re: Create a summary of errors within a row
Ok. So instead of nesting your IFs together, try "adding" them together.
=IF([Type of Work]@row = "", "Type of Work is Blank" + CHAR(10), "") + IF([SET Owner]@row = "", "SET Owner is Blank" + CHAR(10), ""), + ……………………………………….

Re: Welcome to the Healthcare & Life Sciences Community!
Hey there! I am a consultant and healthcare is just one of the many areas I support from a people, process, technology perspective. I’ve been using Smartsheet since 2018. I want to better understand how other professionals and teams are using Smartsheet in the Healthcare & Life Sciences industry to be better prepared for my next contract.

Re: Welcome to the Healthcare & Life Sciences Community!
Hi everyone! My name is Travis Carlile. I currently work at Medalogix in the PMO as a Senior Program Manager (specifically for implementations). I've been using Smartsheet for about 7 years now (2 at Medalogix and 5 at my previous company).
I've utilized Smartsheet in a few different ways, but I primarily use it for Project and Program management in my current role. We utilize Smartsheet Control Center to more efficiently manage project intake requests and standardize our project assets across the program. This has helped us save time and effort when planning projects as there is not much deviation from our holistic plan's approach. I would like to continue growing our usage into different programs and/or resource management, but we are still a small enough company that we haven't matured to this level yet.
I'm interested in learning how you all utilize Smartsheet, which is why I'm in this thread obviously 😊

Re: Welcome to the Healthcare & Life Sciences Community!
@Cathy Salscheider seats will be first come first serve. You'll be able to add the lunch to your schedule in the event app, this won't reserve a seat, but will give a sense of interest (in case we need to/are able to add a table).
Love that Engage is an opportunity for you all to get together in person!
Re: Welcome to the Healthcare & Life Sciences Community!
Is anyone a part of Labcorp? I am wanting to help out a dear friend with an opportunity she saw on their career page.
Re: Welcome to the Healthcare & Life Sciences Community!
Hi, I am Cathy from Overlake Medical Center and Clinics, in Bellevue WA, just down the road from SS headquarters. I am a Sr IS PM using SS for project/ portfolio management
Re: Welcome to the Healthcare & Life Sciences Community!
Hello everyone. My name is Angela! I work for United Health Services and have been employed for 8 years. I currently work in the Project Management department within IT for out healthcare organization as a Project Management Analyst. Currently I am the primary admin for Smartsheet. We implemented Smartsheet about 2 years ago and I have since then been working primarily on optimizing and enhancing the solution for out organization.
Currently at UHS we utilize Smartsheet primarily for IT project related work, and are starting to venture out to other areas of the organization such as Human Resources. I would love to learn more about how everyone in the healthcare field is utilizing Smartsheet in various ways!

Re: Introduce yourself & get to know your peers!
So many new introductions in the last month, and quite a few of you shared more about yourselves after our Jumpstart 2025 with Community party. 👀 Thank you for being a part of the Smartsheet Community, so happy to greet you all!
@NickSakers, @Elden Steele, @AngieN., @Emmett Tomkinson, @rgoodwin_emb, @Gina T, @Shawn Cullen, @Brian Wilson DC, @Jen6122, @Marlei, @ChrisJ2025, @cdellaluna, @KBaker, @MRBJenH, @jrhodes, @Nicole Walker Boyer, @Susan Hornberger, @Amy_NSW_Sydney, @Ben Westlake, @cnikkih, @Lynne D, @Jason Miller, and @WILB. 👋
February marks the Community's 10th anniversary, so keep an eye out for more celebrations coming soon.

Re: Formula error
Hey @Leighmercado !
I would add CONTAINS like:
=COUNTIFS({MBF Open SB Range 3}, CONTAINS("737", @cell), {MBF Open SB Range 4}, CONTAINS("top kit", @cell))
Does this work?

Re: February Question of the Month - Join the conversation and receive a badge
If you could create a new badge in Community, what would it be?
This is a great question for this month, and there are so many great ideas, I can't wait to see the rest of this month's responses. But if I could create a new badge in the Community I would make a badge that reflects your participation in the Question of the Month conversations for an entire calendar year and have it be recurring for those who participate each and every month for each year (similar to the Smartsheet Anniversary badge) but for these Question of the Month participants!
I also think a badge for those of us who have collected 100 or more badges might be a fun one. Maybe a "Milestones Badge," "Badge Collector," or "Badge Master" … Gotta have 'em all (lol).