Formula or Rules to AutoPopulate Columns in Sheet
I have a master data sheet where a team of 30+ people will be adding 2021 data and creating our annual plan.
To make it easier for them to complete the sheet, I wanted to have the ability to autopopulate certain columns based on their answer from a drop down choice in an earlier column.
As an example:
1) If they select "Specific Product Name" as a drop down choice, I want to autopopulate "Therapeutic Area" and "Business Area" and "Sub Business Area" columns automatically.
2) If they select "Program type" as a drop down choice, I want to autopopulate "Program Weight" category.
I wasn't sure if that was done using a formula, automation or rule, or if I had to cross reference a separate data sheet.
I have been searching the forum and don't seem to find this specific situation.
Thank you for your help!
Help Article Resources
Check out the Formula Handbook template!