I have a need to populate a drop down list from the data in another sheet. Example - active projects list to populate the drop down "project name" in a communications intake form. Is this possible? So my project intake form is the data sheet for a vlookup for communications sheet?
I am trying to create a SUMIFS formula that will allow me to pull data from the following columns: Region: APAC (There are several offices that make up the APAC region) OfficeStatus: Closed OfficeHeadCount: Sum Total (For example 8 APAC Offices so want the sum of all their headcount in closed offices) I have this formula…
I am trying to create a COUNTIFs for a metric that I need for COVID-19 tracking. I have a datasheet: LOB, and Record Type LOB is a drop down Record type is a drop down either travel or isolation I want to be able to pair up LOB and the # of employees in isolation (Record Type) Example: LOB (Corporte) : Record Type =…
