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
Bookmarks