Help w/automatic Status formula

jmo
jmo ✭✭✭✭✭✭
edited 07/07/21 in Formulas and Functions

Hi team - I have a Status column that includes:

  • Not Started
  • In Progress
  • Complete

I created this formula that appears to work other than when all required fields have information, it does not go to Complete:

=IF(COUNTIF([1. Aware of XXX vulnerability?]@row, <>"") + COUNTIF([2. Does org use XXX XXX?]@row, <>"") + COUNTIF([3a. Action steps implemented?]@row, <>"") + COUNTIF([3a1. Describe steps]@row, <>"") + COUNTIF([3b. Networked accessed?]@row, <>"") + COUNTIF([3b1. Verifications]@row, <>"") + COUNTIF([3b2. Plans to verify]@row, <>"") = 0, "Not Started", "In Progress")

image.png


What am I missing?

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!