Cells on Report not displaying data from source sheet.
I have a new report that I am working on and am having trouble with it because it is leaving cells blank that have data shown on source sheet. Below is a screenshot of the data displayed on the source sheet. That data is formula driven.
PROJECT NAME COLUMN FORMULA:
=IF([Parent Row]@row = 0, PARENT([Job Name]@row), [Job Name]@row)
PARENT ROW FORMULA:
=IF(COUNT(PARENT()) = 0, 1)
Below is a screen shot of the Cells from the report.
I'm stumped. Can anyone help me get this data to show up correctly on the report? I need it to apply filters and groupings.
Help Article Resources
Check out the Formula Handbook template!