IF statement formula help


I am trying to create a IF statement for the following. If submission-1 is "Complete" or "N/A" to reflect 7.

Here is what I have so far =IF([Submissions- 1]@row = "complete", 7, 0)

I'm not sure how to add the second layer.

Thank you for your help!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!