ElizabethSchlag
4 months agoQrew Trainee
IF AND Formula
I am trying to write a report formula that is triggered off a checkbox and two different dates that I would typically write an IF AND formula. Anyone know how to make this work? It is giving me an 'expecting ,' error.
- The Cybersecurity field is a checkbox.
- The Engagement Begins is a date field.
- The Cybersecurity Discovery Engagement Ends is a date field.
The logic should read if the Cybersecurity checkbox is checked AND the Engagement Begins field is blank, then the field should read "Upcoming", but if the Cybersecurity checkbox is checked AND the Engagement Begins field is not blank, and the Cybersecurity Discovery Engagement Ends field is blank, then the field should read "Assigned", otherwise show nothing.