Populate % Complete when Actual End is a date

Dee Barnard · 10/14/19

I want to populate the % Percent field with 100 when the Actual End Date is entered. I tried this formula but I get an error.

=IF([Actual End Date]@row > "0", "100", "0")

Any suggestions?

Andrée Starå · 10/14/19

Hi Dee,

Try this.

=IF(NOT(ISBLANK([Actual End Date]@row)), 1)

Hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Andrée Starå · 10/14/19

To add because I can't edit: Have a fantastic week!

Dee Barnard · 10/14/19

Thank you and it works when I turn off % Complete in Project Settings. But then it wont calculate overall project % complete. I am stuck.

Andrée Starå · 10/15/19

Happy to help!

Unfortunately, you can't have both.

You'd have to disable the automatic % Complete feature and add manual formulas instead.

Would that work?

Another option could be a third-party integration like Zapier or the Smartsheet API. Is that an option?

Paul Newcome · 10/16/19

I am getting blocked with edits again as well... -_-

Andrée Starå · 10/17/19

Yes, i get sometimes now as well.

It's back!

itsback

Paul Newcome · 10/17/19

HAHAHAHAHAHAHAHAHA!!!!!!!!!!!

Andrée Starå · 10/17/19

Comments