Hello Everyone,

I'm working on creating a spreadsheet to help engineers produce survey reports.
i'd like to create a sheet where the engineer chooses the relevant discipline in the firstcolumn (Mechanical/Electrical) then this will inform the visible options in the next column ('Service'), which will then inform the next list ('Description') each step only showing the relevant options filtered down


Image below,

Screenshot 2023-08-29 094116.png

Any advice would be greatly appreciated,


Thanks,
Carl