Welcome!

Formula Help

I am trying to have a formula in a cell that will total "1" if the Assigned to Column is a certain name, and the Status Column is QA, or fielded.

This is what I have and I need Help please..... I know it is so wrong but I am lost on how to correct it.

=IF(STATUS672 = "QA" OR(STATUS672 = "FIELDED"AND([QA Assigned To]672 = "Bill"), "1")

Find more posts tagged with

Comments

e.mcinnes66356

I have come up with this, but I can't get the OR condition for the Status Column for (STATUS672 = "QA") entered without UNPARSEBLE showing up.

=IF(AND([QA Assigned To]672 = "Bill", (STATUS672 = "FIELDED")), "1", "0")

Jacques@SBP

The way to do an OR with IFs is to do a "nested IF". Try this:

=IF(STATUS@row = "QA", 1, IF(AND([QA Assigned To]@row = "Bill", (STATUS@row = "FIELDED")), "1", "0"))

e.mcinnes66356

That worked Perfectly, Thank you so much!

e.mcinnes66356

actually it only worked in Bill's column, when I copied the formula to Lorne's column and put his name in it still showed a 1 count even though it was Bills name in the QA Assigned to column.

And when the status changes to submitted it still shows 1 . I only want a count of 1 to enter into the cell if the status is QA or Fielded

Paul Newcome

Give this a try...

=IF(AND([QA Assigned To]@row = "Bill", OR(STATUS@row = "QA", STATUS@row = "FIELDED")), 1)

Sign in to join the conversation!

Quick Links

Trending discussions

Is it possible to edit an email list in an automated monthly report?
I have a monthly report I send out that has a long list of recipients. I know I can edit the recurrence of it being sent, but does anyone know of an easy way to just add or take out people that get my email without having to recreate the whole thing?
User Friendly Search
We would like to allow conference attendees to check themselves in using tablets at the conference center. I know there is a "find in sheet" magnifying glass in table view, but it is not super obvious, especially for non-Smartsheet users. Is there a better way for them to easily find their row among all the attendees so…
2 part automation delay question?
Greetings- I have a automation setup when I select the "status" column drop-down to "completed" I want the row info to be emailed to the contact to submitted it with a follow up then I want it to archive the row (aka move to another sheet). When I run the automation only 1 of the 2 requests happen. The archive happens…