Populate % Complete when Actual End is a date

Dee Barnard

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å

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å

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

Dee Barnard

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å

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

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

Andrée Starå

Yes, i get sometimes now as well.

It's back!

 

Paul Newcome

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

Andrée Starå