Can't add formula to existing Column

Todd Smelser

I have a %complete column that is used as an input to other formulas in the sheet but has no formula added to it specifically. I am trying to add a formula to calculate the percentage based on the difference in start and end dates. This formula works well in other sheets.

However, when I try to add any logic beginning with "=" to the column, an apostrophe is added before the "=" and this prevents the logic from being seen as a formula:

'=IFERROR(IF(ISBLANK(Start@row), ....

Why is this apostrophe being added and how can I make this work properly?

Andrée Starå

Hi @TSmelser

You are probably using Dependencies, and then you can't use formulas in the date columns set in the project settings.

Make sense?

Was that the issue?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @TSmelser

You are probably using Dependencies, and then you can't use formulas in the date columns set in the project settings.

Make sense?

Was that the issue?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!