Conditional/customized formulized data validation

Rajnandini Agrawal

Hi community,

I have question about the data representation in a sheet. So I have two columns, Column A with the task name and columns B within column A which has subtasks mentioned. I want a way to add a condition such that particular sub tasks are displayed based on the condition and not all the sub tasks are visible at once when I open column A.

Hollie Green

To my knowledge this is not an option currently on the sheet however you can use a form to add new rows to a sheet and use logic in the form to show different columns then combine the columns with a formula in a helper column on the sheet to prevent others from choosing the incorrect option.

Andrée Starå

Hi @Rajnandini Agrawal

I hope you're well and safe!

You could either use filters or reports for that.

Can you elaborate? What should show/not show when?

Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

Would any of those options 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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Rajnandini Agrawal

image.png

Hi Andree,

Thanks for the response.

Have a look at the image I think it explains my question properly.

Hollie Green

To my knowledge this is not an option currently on the sheet however you can use a form to add new rows to a sheet and use logic in the form to show different columns then combine the columns with a formula in a helper column on the sheet to prevent others from choosing the incorrect option.

Andrée Starå

@Rajnandini Agrawal

Happy to help!

Unfortunately, it's not possible now, but it's an excellent idea!

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

Possible workarounds

• Using a form, and so-called helper columns, If project a, show column 1, b, show 2...
• Using conditional formatting and messaging in the sheet + helper columns. If project a, highlight and show message for column 1, b, show 2...

Make sense?

Would any of those options work/help?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community 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!

Rajnandini Agrawal

Hi Andree, Thanks for the response. We will try the workarounds.

Andrée Starå

@Rajnandini Agrawal

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community 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!