How do I "format" a column to only show my drop down menu if the row has > 3 ancestors?

gkinberg

FYI, I am a rank and file noob and my brain seems impervious to learning logic functions.

Thanks, Garth

Anupriya

This won't be possible in Smartsheet. Smartsheet column settings are same for all the rows.

Andrée Starå

Hi @gkinberg

I hope you're well and safe!

Can you elaborate on how you would like to use it?

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

gkinberg

I feel this should be possible. I created a column "Level" that counts the ancestors for each row. I have another column "Stage" that is a single selection drop down menu with several different options to choose from. My thinking is as follows:

In the "Stage" column header, or in one of the cells below, create an equation such as -

=IF(Level@row>3, [display drop down menu])

I realize the text in brackets [display drop down menu] is not the appropriate string of text in order to initiate the dropdown menu. This is one aspect where I need guidance.

Thanks,

Garth