Best Of
Re: February Question of the Month - Join the conversation and receive a badge
I like the idea of anniversary badges! Are not already there?
AntonioC
Re: February Question of the Month - Join the conversation and receive a badge
There are so many great suggestions here, I hope the community team make them all!
Similar to the Automagican badge which is for use of Smartsheet automation… my new badge(s) suggestion would be for the use of Data Shuttle, Dynamic View, DataMesh, Calender App, Control Centre, Pivot, WorkApps.
Protonsponge
Re: Configure Google Suite App Access Control From Smartsheets
It very much does! Thanks Isaac.
g2smsht
Re: February Question of the Month - Join the conversation and receive a badge
Dashboard Designer - Recognizing users who create compelling designer dashboards.
Ric T
Re: February Question of the Month - Join the conversation and receive a badge
Morning Smartsheet lovers, I am Joe Busch from the DC area and I truly enjoying working with Smartsheet and I have a wife who is my Smartsheet hero!
I would love a badge with the beginning of a path of a mountain forest with snow covered evergreens reaching in the clouds. The badge would reflect on the journeys we take when we enter the Smartsheet forum. Sometimes we are at the beginning, and sometimes reaching an end. But throughout the journey there are guides and helpers; there is wildlife moving through the landscape that distract, at times we hit obstacles like rain clouds that block our visions, at times we see sunlight through the trees and it seems everything is going to be okay…. but the best part of the journey is when you reach the end and can share your adventure with others and encourage them to always know there are helpers at every intersection and never give up!!!!!!!!
Joe Busch
Re: Hours and Minutes calculation
@Adarian Searcy
Try this.
=IFERROR(IF(CONTAINS("hr", [Time Allocation]@row), VALUE(SUBSTITUTE([Time Allocation]@row, "hr", "")) * 60, VALUE(SUBSTITUTE([Time Allocation]@row, "m", ""))), "")
This formula searches for an hr in the time allocation column then returns the value multiplied by 60, If hr is not there it will return the value of min. If neither is in the column it returns a blank.
Mark.poole
Re: February Question of the Month - Join the conversation and receive a badge
Dashboard Queen or King
Isis Taylor
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), ""), + ……………………………………….
Paul Newcome
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.
Yvonne Smythe
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 😊
MedaUser