(Resolved on my own) Formula issue ..

Mel_Barnes

RESOLVED … I WAS USING THE WRONG COLUMN!

I have written a formula to read columns on a different sheet. The column is working (no error messages) but it is reading "0" for everything. I've attached a couple of screenshots that demonstrate this. There is clearly 3 "yes" answers for the project but the formula is returning "0" for every project (including the one shown).

Any ideas?

Genevieve P.

Hey @Mel_Barnes

Thanks for updating your post with your solution! I'm glad you were able to get it to work. 🙂