Formula to set the Task Health.
Hi Good Morning,
I have a question on this formula. Can you tell me what I did wrong please?
Thanks for your great help.
Best Answer
-
Happy to help. 👍️
Answers
-
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).
-
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!
-
Happy to help. 👍️
-
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!
-
Are you using dependencies?
-
-
because if i don't use dependencies, I can get the duration dates.
-
You need to enter end dates.
-
Sorry I don't get it.
-
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.
-
Thank you Paul. I got it now. Have a good day!
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives