Unable to convert column to a formula

betcha663

I am trying to convert the following cell formula to a column formula to adjust the duration relative to the allocation percentage:

=IF(OR(Duration@row = "", Duration@row = 0, [Allocation %]@row = "", [Allocation %]@row = 0), "", ROUND(Duration@row / [Allocation %]@row))

The cell menu option -> "Convert to Column Formula" is dimmed out.

Andrée Starå

Hi @betcha663

I hope you're well and safe!

Ensure you're right-clicking on the cell and not the column.

Was that the issue?

I hope that helps!

Be safe, and have a fantastic weekend!

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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

betcha663

Hi,

Yes, I am right-clicking on the cell. In the pic below, the formula is in the yellow highlighted "Duration with Allocation" cell.

Andrée Starå

@betcha663

Is it set as a system column?

betcha663

How do I verify that?

This is a newly created column

Andrée Starå

@betcha663

Check the project settings to see if it's used as the duration or similar.

betcha663

The "Duration with Allocation" cell is not referenced, but the Allocation % cell is under Resource Management.

To test if that is causing the issue, I "Disabled" Resource Management feature, saved the plan and the "Convert to Column Formula" option is still disabled.

Andrée Starå

@betcha663

Also, ensure that the cell you're right-clicking on has the formula populated.

betcha663

Yes, it does

Andrée Starå

@betcha663

Check this also. Is any of the below true?

Areas where formula use is restricted

These fields can't contain formulas:

• Contact list fields that are being used in resource management
• System fields (for example, Modified By)
• Default columns (attachments, comments, row action indicator)
• The following fields being used for dependencies and resource management:
  • Start Date
  • End Date
  • Duration
  • Predecessors
  • % Complete

betcha663

"Duration with Allocation" is a new column I created. I am able to insert the formula. It calculates correctly. It is not used in the project settings. The cell menu option "Convert to Column Formula" is not available.

Andrée Starå

@betcha663

So strange!

I'd be happy to take a quick look.

Can you share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

betcha663

I provided you access to a slimmed down version copy. Please disregard the first message.

Andrée Starå

@betcha663

I figured it out!

You can't use column formulas on the Duration type column. I learned something new! 😉

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