Can I create headers and subheaders in a spreadsheet without there being data.

Bartow_R1001

I'm very new to this. I'm trying to create headers and subheaders (lising program names) in a single spreadsheet using the indent function then color formatting the header and subheader rows. When I make a report, I don't want the headers to show errors because they are missing information. I just want the data fields to be underneath the headers/subheaders. Then when setting rules for the columns and when pulling information into the report, the program will know how I want the information listed (ie. by program area). Similarly, I want to input our strategic plan and list the goal, objectives, then activities underneath, and only want the activities to have the information required by the columns. Is there a right way to do this?

KPH

To answer your first question, you can add a column to your sheet to help define what appears in the reports. For example, you could use a formula to count the number of child rows, and then filter in your report to only show rows that have 0 children (this would remove the headings). Does that sound like what you need?

KPH

To answer your first question, you can add a column to your sheet to help define what appears in the reports. For example, you could use a formula to count the number of child rows, and then filter in your report to only show rows that have 0 children (this would remove the headings). Does that sound like what you need?

Bartow_R1001

Yes, thank you!

KPH

Great! Thanks for letting me know.