CountIfs formula- one column w/ multiple conditions and a 2nd column w/ one condition

Options

Hello,

I am not expert in setting up formulas and would like to ask for some help with a formula I am setting up for a sheet summary field. This is what I have and it is not working:

=COUNTIFS([Primary Applicant Status]1:[Primary Applicant Status]22, "Verified income", "Applicant completed rental profile", "Signed up"), [Invalid Application]1:[Invalid Application]22, 0)

I'm trying to get a count of the 3 values in one column BUT ONLY if the value in a different column is "0" for each row.

Please, help, anyone. Thank you so much, in advance!

--Lisa

Best Answer

Answers

  • Lisa Matthews
    Lisa Matthews ✭✭✭✭✭
    Options

    Hello,

    Thank you so much!! You are FABULOUS! This worked!!!! You are correct, I wanted to look at the entire column.

    Your reply was the best news of my Monday!!!

    :) Lisa

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Options

    Lisa

    I was happy to help.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!