Best Of
Re: Smartsheet training on LinkedIn
Hello @kowal while not completed yet, this is what I'm seeing on this training:
Structure: Introduction, Solution initiation, Solution Planning, Project Creation and Execution, Project Closure, Project and Portfolio Management, Enhancing team performance, and Conclusion. Each of these areas has its own sub-topics. It follows most of the PM steps (excluding monitoring and control).
Instructor: Jeremy Williams. Do a good job in presenting and referencing content. Articulated and with a logical flow. I'll look for Jeremy here in our community. Thank you!

Re: Automation Workflow - Task Due Soon Not Recognizing End Date
This seems very strange. It should not be sending everything. That is very strange behavior. Looking at it, it seems set up correctly. Maybe try this extra condition?
Re: February Question of the Month - Join the conversation and receive a badge
Workflow Sensei - For those who like to utilize workflows for many different avenues as well as process improvement.

Re: How to show % complete compared days in a year
I was actually able to get it with this formula:
=(TODAY() - DATE(YEAR(TODAY()) - 1, 7, 1)) / 365
Getting the hang of SmartSheets π

Re: Datashuttle: source not found when updated
You can have that new file attached to a form every week and moved into the sheet with Data Shuttle instead. I have this setup myself for several updates.
Re: Community Corner Newsletter [February 2025]
Beautiful pictures! Thank you for sharing!

Re: Whats wrong with this nested if and vlookup formula?
Happy to help. ποΈ
A quick tip: If you catch yourself repeating the same pieces of a formula over and over again with the only difference being a single variable based on an IF, you can nest the IF inside the other formula.
=VLOOKUP([Month/Year]@row, {Budgeted Cost Test Kits Range 1},Β nested IF to only output number based on test type, false)
I personally would build out the nested IF first in one cell to just output the column number based on the test type. Then in another cell write the VLOOKUP and use a cell reference in it to reference the cell containing the nested IF. This will help you make sure everything is working as expected and makes troubleshooting a bit easier.
Finally you would copy the entire nested IF (without the initial equals) and simply paste it into the VLOOKUP where the cell reference is. If you do this in a third column, troubleshooting is much much easier because you will know that the two individual pieces are working and you only need to figure out what is wrong with the nesting.

Re: Community Recommendations - Let's share our favorites!
I'll get us started with a recommendation of my own. π±
Last weekend, I went to watch "Flow" and was pleasantly surprised by it. I didn't know anything about it going in, and I think that was for the best, because the movie surprised me at every turn.
I won't give you any spoilers, but if you watch it, (or any similar movies π) I would love to know your thoughts!

Re: February Question of the Month - Join the conversation and receive a badge
How about training badges? I didn't see them, but I am pretty new⦠but badges for completing Smartsheet University courses?

Re: February Question of the Month - Join the conversation and receive a badge
I would like to see a badge that emphasizes continual engagement. Often, in communities, when people first join they are very actively involved. They get whatever accolades they are looking for, or the answers to the questions they need and then move on. I'd love to see a Continuous Engagement award that rewards people for a particular threshold of engagement month-to-month. There would be a 3 month, 6 months, 1 year and then yearly award after that. With the count starting over if you miss a month. It could be as simple as contribute to one posed question and make at least 2 posts. But some level of engagement needs to be measured.
