Best Of
Re: March Question of the Month - Join the conversation and receive a badge
The skill I would like to improve is my selling skills, selling a great idea to executives, better at selling what my accomplishments are, etc…..
AnthonyxXx
Re: March Question of the Month - Join the conversation and receive a badge
I have been reading the coaching Habit and learning to say less, ask more and change the way I lead.
DavidY
Re: March Question of the Month - Join the conversation and receive a badge
One skill I'd like to improve in relation to health and Crohn's disease would be a deeper understanding of how diet and nutrition impact the disease. While I know that Crohn's disease is an inflammatory bowel condition, I would love to learn more about which specific foods and nutrients can help manage symptoms or even reduce flare-ups. There’s a lot of research out there, and understanding the nuanced relationship between food, the microbiome, and immune response in Crohn's could be incredibly helpful for those managing the condition.
AngB789
Re: March Question of the Month - Join the conversation and receive a badge
Hi community,
many skills could be improved but on the Smartsheet side I currently would pick WorkApps sourced by SCC. Working on that ;-)
On the personal side I'd love to improve my quick-wittedness similar to the what you see in the film "Amélie" ;-)
Stefan
Re: Happy 10th Anniversary Community + Giveaway!
Smartsheet is a web-based work management platform that lets me organize, automate, and visually communicate the work of my team.
:)
And is also my favorite tool ever!
Jennifer Kurtz
Re: Trouble with IF statement and date format conversion
Happy to help. 👍️
That formula in your last comment is accounting for moving from December to January using the IFERROR.
=IFERROR(DATE(yyyy, mm + 1, 1), DATE(yyyy, 1, 1))
Paul Newcome
Re: How do I write a formula to use multiple columns in a single cross-sheet reference.
Depending on what you are trying to pull off, this may be straightforward or may be an absolute nightmare. Certainly you can make a cross sheet reference to more than one column - figuring out how to use it in a formula is a bit trickier. With no direct equivalent to the "offset()" function in excel, the two methods I've seen used are vlookup() and index({inputRange},match(),match()) with the input range being multiple columns in a single reference. Both have weaknesses and ways they can go wrong, but are paths that might work for you. More specific advice would require more specific levels of details.
Jgorsich
Re: Help with COUNTIFS function
Hi Eric,
To set up the formula in another sheet it would look something like the below equation:
=COUNTIFS({Range Related Product},"Envarsus",{Range Qtr Due}, "Q1 FY25")
This formula would give the count of all rows that have Envarsus in the Related Product column and Q1 FY25 in the Qtr Due column. When you're in the other sheet entering the column reference, choose Reference Another Sheet and then navigate to this sheet and choose the appropriate column.
If the two columns you're using in the Count Ifs function are not dropdowns that have standardized entries but instead might have the text you're looking for you could do this:
=COUNTIFS({Range Related Product},CONTAINS("Envarsus",@cell),{Range Qtr Due}, CONTAINS("Q1 FY25",@cell))
Hope this helps!
Elska19
Re: See a form and not spreadsheet
I forgot to update the ticket on Friday.
Yes! The form does open as it should
cswicegood
To the Incredible women in the Smartsheet Community
To the incredible women in the Smartsheet Community and all women around the world.
Not just today on International Women's Day, but every day — thank you for your hard work, strength, and dedication.
While we may not always express it as well as we should, know that we respect, admire, and appreciate all that you do.
I have the privilege of working alongside talented, inspiring women who lead, support, and make a difference every single day. If I could embody even half of their dedication and excellence, I would consider myself fortunate.
So today, and every day, thank you for making our Smartsheet Community, and the world, a better place.
Protonsponge
Protonsponge