Best Of
Re: Trend curve/ Variation
If you're creating a new text column you shouldn't have an issue putting in a formula. Are you getting an error message?
Could you paste the formula you're trying to enter?
Adam Costello
Re: Trend curve/ Variation
Have you considered setting up the Baselines in your project sheet? I think it would resolve your issue as variance between planned date and actual date would calculate automatically.
https://help.smartsheet.com/articles/2482093-baselines
kowal
Re: Help with Index/Match + if blank
The initial
"")
is the output of the IFERROR. If there isn't a match with the INDEX/MATCH, the IFERROR outputs a blank.
<> ""
means "is not blank", so if there is a match and the cell it pulls over is not blank
That final comma in your last question is the transition between the logical argument of the IF statement and the output if true.
The formula essentially says "If there is a match for the {Re 2} column and it is not blank then output that, otherwise check the {Rev 1} column. If that has a non-blank match, output that, otherwise check the {PO Value} column and use the same logic.
Paul Newcome
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!
harocha
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.
AngB789
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 😀
Test Case 123
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!
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