Convert to Column Formula option is missing from my menu

Elizabeth Smeller

Hi, I'm the Admin of this sheet, but when I right click on the Formula column, I don't see the option to 'Convert to Column Formula' in the menu. Am I missing something?

Andrée Starå

Hi @Elizabeth Smeller

I hope you're well and safe!

You'll have to right-click on one of the cells in the column instead.

Did that work/help?

I hope that helps!

Be safe and have a fantastic day!

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!

Andrée Starå

Hi @Elizabeth Smeller

I hope you're well and safe!

You'll have to right-click on one of the cells in the column instead.

Did that work/help?

I hope that helps!

Be safe and have a fantastic day!

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!

Elizabeth Smeller

Thank you Andree, that worked! Not sure why I didn't try that first lol! :-)

Andrée Starå

@Elizabeth Smeller

Excellent!

Easy to miss!

You're more than welcome!

smurphy

oh my goodness, thank you for the tip on right clicking in the cell, my AI agent didn't even give me correct answer!

Andrée Starå

https://community.smartsheet.com/discussion/comment/489234#Comment_489234

Hi,

I hope you're well and safe!

I'm always happy to help, and I'm glad to hear that it was useful!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer! I appreciate it, thank you! 🙏