Formula for a checkbox when 2 criteria are met

Options
Michelle Lien
Michelle Lien ✭✭
edited 11/16/20 in Formulas and Functions

Hello, I've been trying to figure out how to do this and need some help. I have two sheets:


I want to make the checkbox true when:

  1. case ID FF matches a case ID SE
  2. AND if the caseID SE has the date column filled in (anything except blank)
    1. if the date column is a blank, then the checkbox should be unchecked

So far I can generate a formula asking to search for a matching caseID between both sheets.

=IF(COUNTIF({Case ID SE}, [Case ID FF]@row) > 0, 1, 0)

I tried adding on an AND to the end of the formula but it returns as unparseable.

Any help is appreciated, thanks!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!