Countif coming over as percentage

Hello, for some reason I have one formula using a cross sheet reference that comes over as a percentage when the rest come over as values which is what I want.

I really don't understand why the "complete" formula is coming over as a percentage and not an exact value.

Thank you in advance for the help

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!