Google Sheets - Data Validation - Using Formula in List from range

Question

I am trying to create a custom dropdown for each row depending on the content of a cell in the same row. I have tried several other ways but they do not work when you filter.

The formula I am using will be put in the range section here.

this is the formula :

=concatenate("'Working'!$AG",(match(C2,Working!D:D,0)),":","$AK",(match(C2,Working!D:D,0)))

This would output Working!$AG3:$AK3 which would be a valid range and return the correct result. Help, please

I thought excel users may have an idea of how this could be resolved — Ethan Carlton
– Ethan Carlton, Commented Jun 10, 2022 at 12:07

player0 · Accepted Answer · 2022-06-14 13:48:14Z

3

That is not possible. No formulae other than simple range references can be used in conditional formatting criteria when List from a range is selected

(currently in June 2022)

edited Jun 14, 2022 at 13:48

answered Jun 11, 2022 at 9:52

player0

131k14 gold badges91 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Google Sheets - Data Validation - Using Formula in List from range

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related