Conditional/customized formulized data validation

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.

Best Answer

  • Hollie Green
    Hollie Green ✭✭✭✭✭✭
    Answer ✓

    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.