Can a formula return the name of the column?

A. Jasa

I have a number of checks lists. I would like to make a formula that enters the name of the column if that column's checkbox is ticked. Is that possible? TIA.

Andrée Starå

https://community.smartsheet.com/discussion/136537/can-a-formula-return-the-name-of-the-column

Hi,

I hope you're well and safe!

Unfortunately, there isn't a way to get the column name, but as a workaround, you could add the column names to one of the rows in the sheet and reference them in the formula.

Would 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 comment(s) help/answer your question or solve your problem? Please support the Community and me 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! I appreciate it, thanks!

A. Jasa

Thank, Andree.

That's a good suggestion as a workaround. I'm not sure if that or creating a helper sheet is best in my case. Got to think about implications of both.

Much appreciated.

A. Jasa