Help! Summary Report doesn't recognize one field in dropdown list.

Paulina Guerrero

Im at wits end. Trying to do a summary report, and there is ONE of the dropdown statuses it won't update. There are over 80 Completed items. Ive checked every which way. I even update every single one to be sure they were exact. Won't pull in. Whats odd is that I have a conditional formatting rule that recognizes the status "complete" and performs the correct options.... What am I missing?

zealvert

Dear @Paulina Guerrero -can you please share the summary formula that collects the Status column values?

Please hide any confidential information while sharing.

Would be happy to help!

Paulina Guerrero

Thank you! What do you mean by summary formula? @zealvert

this is the view:

Paulina Guerrero

And this is from the core sheet @zealvert

and when I filter for Complete on the sheet, it produces 86 items. These 86 won't show on the summary report

Paul Newcome

Your first screenshot of a report looks like it is only pulling in a single sheet that appears to have formulas generating the counts. What is the formula that is producing the zero result?

Paulina Guerrero

@Paul Newcome how do i look that up? Im not seeing a formula bar anywhere? I simply created a Summary Report, pulled in the task sheet and asked it to display the fields noted. Its pulling in all other status' but the "Complete"

Paulina Guerrero

I made a different report, using summaries instead of Rollup. got it to work. thanks all for trying to help.