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.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!