How do I calculated Expected Completion %

lwell

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.

Expected % Error.JPG

Krissia B.

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

Paul Newcome

If you do not have dates for that row yet, you can use an IFERROR statement to output a zero:

=IFERROR(IF(.................................), 0)

Krissia B.

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

Paul Newcome

If you do not have dates for that row yet, you can use an IFERROR statement to output a zero:

=IFERROR(IF(.................................), 0)