I'm trying to find a way to create dynamic dependent dropdowns in Proton Sheets WITHOUT creating individual data validation rules per row. It could be that I simply haven't found solutions that are already possible with existing features. I'm finding that the usual solutions from other spreadsheet software don't work in Proton due to peculiarities of how data validation is handled. It seems like cell references in validation functions are always absolute, which makes it hard to set up validation that can simply be dragged down a column when the validation is dependent on a value in another column but same row. ROW() and INDIRECT() also don't work as expected within data validation functions -- it's as though they're evaluated in a separate context, so they return nothing, or return 0. If there's already a good way to solve the dependent dropdowns problem without needing a validation rule for every single row, it would be great if it could be added to the documentation.