Formula to set the Task Health.

AAL

Hi Good Morning,

I have a question on this formula. Can you tell me what I did wrong please?

Thanks for your great help.

Paul Newcome

Happy to help. 👍️

Paul Newcome

Looks like you typed up your formula in Word (or some other similar program) as opposed to directly in Smartsheet. Your slanted quotes are called "smart quotes" which (ironically enough) are not recognized as valid characters in Smartsheet formulas. You will need to retype the formula directly in Smartsheet, here in the Community, or in a text editor such as Notepad to get the appropriate quotes (notice the ones here are straight up and down instead of slanted).

AAL

Thank you so much, Paul. You are right I typed the function in MS Word and copy it. Now I retype it and it works. Thanks again. Have a wonderful day!

Paul Newcome

Happy to help. 👍️

AAL

Sorry Paul,

Can I have another question on the formula, please? Under the % complete, I completed 4 tasks under Parent Row Location, however on the row of Location, it still showed 0% complete. It seems it won't automatically adjust the level of % complete. Do you know what's wrong with that? I did set the formula in the completion Progress column: =IF([% Complete]7 < 0.25, "Empty", IF([% Complete]7 < 0.5, "Quarter", IF([% Complete]7 < 0.75, "Half", IF([% Complete]7 < 1, "Three Quarter", IF([% Complete]7 = 1, "Full"))))). However, I don't know if it will affect the result on the % complete column. Please advise. Thanks!

Paul Newcome

Are you using dependencies?

AAL

Yes

AAL

because if i don't use dependencies, I can get the duration dates.

Paul Newcome

You need to enter end dates.

AAL

Sorry I don't get it.

Paul Newcome

You need to fill in the End Date column for all of the individual tasks. With dependencies turned on, the parent rows will automatically populate.

AAL

Thank you Paul. I got it now. Have a good day!

Paul Newcome

Happy to help. 👍️