3 condition formula- Help

Angelica Landers

Need help with a formula, 3 conditions- 1) Recognize first 3 digits of "ticket number" (EX: "LEG", "ONB", "REV") 2) Recognize when a task is past due 3) Status not "Complete" or "Not Applicable"

What I have so far:

=COUNTIFS({KIM- Project Plan- TEST Range 3}, "LEG", {KIM- Project Plan- TEST Range 1}, >TODAY(), {KIM- Project Plan- TEST Range 2}, "In Progress", {KIM- Project Plan- TEST Range 2}, "Not Started")

Mark Cronk

Try:

=COUNTIFS({KIM- Project Plan- TEST Range 3}, left(@cell,3)="LEG", {KIM- Project Plan- TEST Range 1}, <TODAY(), {KIM- Project Plan- TEST Range 2}, AND(@cell <>"complete", @cell <> "not applicable"))

Mark

Mark Cronk

Try:

=COUNTIFS({KIM- Project Plan- TEST Range 3}, left(@cell,3)="LEG", {KIM- Project Plan- TEST Range 1}, <TODAY(), {KIM- Project Plan- TEST Range 2}, AND(@cell <>"complete", @cell <> "not applicable"))

Mark

Angelica Landers

@Mark Cronk It worked!! thank you so much, this was very helpful!

Mark Cronk

Hi Angelica, Glad you found a solution. Thank you for contributing to the community.

Mark

Angelica Landers

@Mark Cronk Mark, do you do Smartsheet Consulting work or are you just very helpful :) If you do, please connect with me angelica.landers@integritymarketing.com. I also have requested to connect with you on LinkedIn. Thanks in advance!

Mark Cronk

Hi Angelica, Smartsheets is just a hobby for me. No consulting. @Andrée Starå is the pro. I'm happy to connect with you and assist as my time allows.

Mark

Andrée Starå

@Mark Cronk

Thanks so much for the kind words! 😊

Angelica Landers

@Mark Thank you for the recommendation

@Andrea Vecchi What is a good email for you?

Andrée Starå

@Angelica Landers

Feel free to e-mail me at andree@workbold.com, and we will take it from there.