Disappearing Formulas in Locked Column

Amber Jackson

I have a locked column with a formula used for a calculation. The formula is dragged all the way down.

The formula keeps disappearing within blank cells. The activity log says it is changed by cell link. I keep dragging down the formulas and saving, but it just resets again.

Any ideas?

Andrée Starå

@Amber Jackson

Happy to help!

Yes, it's fantastic!

No, particular downsides, but it can be useful to know that it's all or nothing, and it doesn't work with row numbers or similar.

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

Andrée Starå

Hi @Amber Jackson

Strange!

Have you tried using the Column Formula feature instead?

Did that work/help?

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

Amber Jackson

Hi @Andrée Starå

Yes it is strange!

I am not familiar with the column formula. Can you direct me please?

Andrée Starå

@Amber Jackson

Have a look here.

https://help.smartsheet.com/articles/2481944-set-formulas-for-all-rows-with-column-formulas

Amber Jackson

@Andrée Starå this is wonderful! I feel like I need to make every formula a column formula. Is there any downside to doing this?

Thank so much!

Andrée Starå

@Amber Jackson

Happy to help!

Yes, it's fantastic!

No, particular downsides, but it can be useful to know that it's all or nothing, and it doesn't work with row numbers or similar.

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

Amber Jackson

Thanks for all your help @Andrée Starå!

Andrée Starå

@Amber Jackson

You're more than welcome!