Best Of
Re: Community Corner Newsletter [February 2025]
Beautiful pictures! Thank you for sharing!
mcullen
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.
Paul Newcome
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!
Rebeca S.
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?
Lynnette
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.
Brian Wilson DC
Re: Smartsheet to Salesforce Connector - Starting Over
Hello @robertDavis !!
Here is an article that might be a good resource to troubleshoot as well as suggestions for what to do in these situations. If this does not properly answer your questions, I am more than happy to jump on quick call on zoom to assist in trouble shooting and starting over. Link to my calendar in my signature below. 😊
Re: Whats wrong with this nested if and vlookup formula?
You are closing out each IF statement before moving on to the next, but they need to be left open so that it is the "value if false" portion of the IF before. Notice the locations of the closing parenthesis in the below examples.
You have
=IF(this = this, do this), IF(that = that, do that)
You should have
=IF(this = this, do this, IF(that = that, do that))
Paul Newcome
Re: Personal Identification Information
Does your IT team have a specific concern? There is a lot of info on smartsheet security here
And here
And that second link has an option to contact Smartsheet security team who could help address the concerns.
KPH
Re: Personal Identification Information
Hello @rachmavis ,
I work in Pharma and we are able to utilize Smartsheet that is IT approved for specific operations.
Below is my holistic approach. You should have your Smartsheet CSM in the meeting with IT. Your Smartsheet CSM should have a technical resource (if needed) to address IT security concerns as these should have been addressed prior to contract installment.
1) Identify applicable Stakeholders: Leadership, Finance, Legal, HR, Compliance, IT, etc.
2) Discovery meeting with Stakeholders kick off only
3) Schedule break out meetings by Stakeholder Roles for requirement gathering
4) Demand Specification Form documentation
5) Meet with Stakeholders to review Demand Specification Form
6) Upon email approval, build, test and deploy
I actually create Test Scripts in Smartsheet housed in a folder in the same Workspace as the solution. That way it is easily accessible when IT Auditors want to review for security and sustainability of the solution.
Happy to have a discussion to help your frame your Smartsheet goals for adoption.
