How do I calculate % complete for different phases 1-4?

dkroneme

dkroneme ✭✭

09/18/24 in Formulas and Functions

0 ·

Answers

NicoLHC ✭✭✭✭✭✭

09/18/24

@dkroneme did you update the settings in the gant chart project settings? It should calculate automatic.

If my comment helps you, I appreciate a 💡
Kind regards
Nico | LinkedIn
CEO | Lighthouse Consultings
Lecturer in Business Information Systems | DHBW
________________________________________________________________________________
addvalue@lighthouseconsultings.com
We offer Licenses - Training - Solution Engineering
🔴 GOLD Smartsheet Partner _______________________________________________
💯 SCALEABLE Solutions Engineered by Lighthouse Consultings
We Don’t Just Implement Smartsheet; We Revolutionize How You Manage, Plan, And Execute.
🎥 YouTube 🚀TimeLine View
http://lighthouseconsultings.de/
0 · Share on Facebook Share on Twitter
dkroneme ✭✭

09/18/24

Not yet, where do I go to do this, sorry new at this.

0 · Share on Facebook Share on Twitter
NicoLHC ✭✭✭✭✭✭

09/18/24

If my comment helps you, I appreciate a 💡
Kind regards
Nico | LinkedIn
CEO | Lighthouse Consultings
Lecturer in Business Information Systems | DHBW
________________________________________________________________________________
addvalue@lighthouseconsultings.com
We offer Licenses - Training - Solution Engineering
🔴 GOLD Smartsheet Partner _______________________________________________
💯 SCALEABLE Solutions Engineered by Lighthouse Consultings
We Don’t Just Implement Smartsheet; We Revolutionize How You Manage, Plan, And Execute.
🎥 YouTube 🚀TimeLine View
http://lighthouseconsultings.de/
0 · Share on Facebook Share on Twitter
dkroneme ✭✭

09/18/24

ok, found this below, where do I update?

0 · Share on Facebook Share on Twitter
NicoLHC ✭✭✭✭✭✭

09/18/24

@dkroneme should work now or not?

If my comment helps you, I appreciate a 💡
Kind regards
Nico | LinkedIn
CEO | Lighthouse Consultings
Lecturer in Business Information Systems | DHBW
________________________________________________________________________________
addvalue@lighthouseconsultings.com
We offer Licenses - Training - Solution Engineering
🔴 GOLD Smartsheet Partner _______________________________________________
💯 SCALEABLE Solutions Engineered by Lighthouse Consultings
We Don’t Just Implement Smartsheet; We Revolutionize How You Manage, Plan, And Execute.
🎥 YouTube 🚀TimeLine View
http://lighthouseconsultings.de/
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Multiple IF Statements Using "ISDATE"
I have an existing formula that enters text based on two criteria: if a date exists in a column, and if that item was closed prior to the anticipated delivery date. The current formula is: =IF(ISDATE([Closed Date]1), IF([Delivery Date]1 > [Closed Date]1, "Complete", "Fail")) I'd like to add an additional criterion that…
Formula
I am trying to identify how many surveys taken at the start of the program are from the Jacksonville market using this formula =COUNTIFS({Time of Survey}, {Time of Survey}, "Week 1 of program", {Data}, "FLJAC Jacksonville") but it retuns as Incorrect # of arguments
Conditional formatting to help input mask/ensure social security has 9 digits
I've labored over trying to figure how to get around how SS gets input and for it to highlit if it doesn't contain 9 digits and hyphens. …as I'm typing this, I guess I could do it the same way I did my zip code and just leave out hyphens and have them inected into another column…. I'll work on that until I see someone has…