How do I calculated Expected Completion %
Hi!
My Smartsheet rep designed a formula for me but it's no longer working. I don't know what I changed to cause the error. I am trying to calculate if a project is ahead or behind schedule.
Here is what I have that is returning the error #INVALISD DATA TYPE
Assistance is very much appreciated.
Best Answers
-
Hello @lwell
Thank you for posting! After reviewing your screenshot & testing your formula, the error message your receiving is happening because you need to put something in those date cells. See image below for reference.
See more about this in the link below.
- Formula Error Messages
- Calculate Key Project Metrics With Sheet Summary Formulas
- Take Full Advantage of Sheet Summary: Tips and Best Practices
Hope this helps!
Cheers~
Krissia
-
If you do not have dates for that row yet, you can use an IFERROR statement to output a zero:
=IFERROR(IF(.................................), 0)
Answers
-
Hello @lwell
Thank you for posting! After reviewing your screenshot & testing your formula, the error message your receiving is happening because you need to put something in those date cells. See image below for reference.
See more about this in the link below.
- Formula Error Messages
- Calculate Key Project Metrics With Sheet Summary Formulas
- Take Full Advantage of Sheet Summary: Tips and Best Practices
Hope this helps!
Cheers~
Krissia
-
If you do not have dates for that row yet, you can use an IFERROR statement to output a zero:
=IFERROR(IF(.................................), 0)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 216 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!