I have column A with the breakdown option and have columns B and C, what is the formula if someone chooses A1,A2 it will link to column B and if choose A3,A4 it will link with column C?
+18You'll need to use an automation for that. An example would be making it trigger whenever column A is updated, and using conditional logic to update column B and C as required
I recommend checking out the automation documentation
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.