keeping columns hidden

Khari Shiver

Hello,

I have three sheets A, B, and C where an automation copies a row from A to B or A to C when certain conditions are met. Sheet A has three columns, "occupation 1," "occupation 2," "occupation 3" where only one value is present in one of the three cells. I have a formula that copies the value from the cell that is not blank to a column labeled "occupation." Sheets B and C have all three, 1-3, occupation columns but two are hidden in each sheet. leaving only one visible. If a row is copied and has data in one of the hidden cells, the column unhides itself. Is there a way to keep it hidden?

Thanks.

Khari Shiver

Thanks Andree! I'll reach out to support.

Andrée Starå

Hi @Khari Shiver

I hope you're well and safe!

Strange!

I'm almost 100 % sure that it's not supposed to do that, or maybe something changed recently.

If you haven’t already, I would recommend that you reach out to the Smartsheet Support Team.

Let me know what you find out.

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!

Khari Shiver

Thanks Andree! I'll reach out to support.

Andrée Starå

@Khari Shiver

Excellent!

You're more than welcome!

Let me know what you find out.

✅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!