Hi @Helena P.

The reason you're seeing unparseable is because the @cell function needs to be all lower case. In the OR function you have a capital C in the @Cell, which will mean it won't work.

That said, excluding cells that say "Approved" will then include cells that are blank (since they do not say "Approved").

Try it again:

=COUNTIFS({Wave 2 WRICEFU Design & Build Tracker Range 2}, <>"12 Descoped", {Wave 2 WRICEFU Design & Build Tracker Range 4}, <>"Approved", {Wave 2 WRICEFU Design & Build Tracker Range 11}, <TODAY())

Cheers,
Genevieve

Hi @Helena P.

That looks to be the same formula as before - have you removed out the @Cell and = "" reference?

=COUNTIFS({Wave 2 WRICEFU Design & Build Tracker Range 2}, <> "12 Descoped", {Wave 2 WRICEFU Design & Build Tracker Range 4}, @cell <>"Approved", {Wave 2 WRICEFU Design & Build Tracker Range 11}, <TODAY())

An Invalid Reference error means that one of the references is potentially set up incorrectly. Double check that each of these are pointing to the right column:

{Wave 2 WRICEFU Design & Build Tracker Range 2}
{Wave 2 WRICEFU Design & Build Tracker Range 4}
{Wave 2 WRICEFU Design & Build Tracker Range 11}

Hi @Helena P.

In this instance, the OR statement is not being closed off OR( - - - )

=COUNTIFS([Overall WRICEFU Status]:[Overall WRICEFU Status], <>"12 Descoped", [Functional Approver(PDL) approval]:[Functional Approver(PDL) approval], OR(@cell = "Submitted", @cell = "Needs Re-Work", @cell = ""), [FS PDL + LPO + Int. Lead Approval Date]:[FS PDL + LPO + Int. Lead Approval Date], <TODAY())