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