Why is Dynamic View only pulling through one set of drop downs for a specific column?
I am new to using Dynamic View. I have three sheets that I combined into a row report and then have been trying to create my view off of that report. I have a column named request type on all three sheets and each sheets has different drop down options for that request type column. When I go to do conditional formatting the drop down options only show for one of the sheets instead of all three. How can I get all three options to show for conditional formatting? Thanks!