Best Of
Re: March Question of the Month - Join the conversation and receive a badge
One career skill that I would really like to improve is effective change management. I find that change management tends to be one of the more difficult pieces of successfully executing a Smartsheet solution implementation.
SDURKEE_01
Re: March Question of the Month - Join the conversation and receive a badge
I would like to improve my use of Smartsheet Dashboards on the work side. On the home side, I would like to improve my turn time in my Resell business.
JoHanna_Schultz
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