CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
Insankesepian
Insankesepian

Reputation: 17

Google Sheets Drop Down change automatically bases on cells value

How to make drop-down in B4 until B5 automatically change either to Milo or Coco based on value in C4 and C5.

When i put 0 in column C4 until C5, the drop down automatically changes to Milo.

And anything greater than 0 in column C4 and C5 changes the drop down to Coco.

enter image description here

Upvotes: 1

Views: 110

Answers (1)

Daniel H.
Daniel H.

Reputation: 680

Try using an ARRAYFORMULA together with IFS. You can see the documentation here and here respectively.

For example: =ARRAYFORMULA(IF(C4:C5="","",IFS(C4:C5=0,"Milo",C4:C5>0,"Coco",C4:C5<0,"Less")))

This will first check if C4:C5 is blank. If they're blank, C4:C5 will stay blank. If not, it will check if the values C4:C5 are equal to zero. If yes, it will show Milo, otherwise, if C4:C5>0, it will show Coco.

If you post the formula you are trying to use, I may be able to adapt it.

Upvotes: 2

Related Questions