Column dependency on another column

Itay

Hi everyone,

I want the cells in the next column to not be editable until I have filled an accurate values in the current column.

For example:

I want that nobody would be able to fill the Practices column before they chose the two values in the Lectures column.

Paul Newcome

That is currently not possible within the Smartsheet core program, but it can be accomplished with the Dynamic View add-on.

Andrée Starå

Hi @Itay

I hope you're well and safe!

To add to Paul's excellent advice/answer.

Another option could be to show a message that it's not ok/ok to add the information, and it could also be combined with conditional formating.

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

Paul Newcome

That is currently not possible within the Smartsheet core program, but it can be accomplished with the Dynamic View add-on.

Andrée Starå

Hi @Itay

I hope you're well and safe!

To add to Paul's excellent advice/answer.

Another option could be to show a message that it's not ok/ok to add the information, and it could also be combined with conditional formating.

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