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")
Comments
-
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")
-
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"))
-
That worked Perfectly, Thank you so much!
-
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
-
Give this a try...
=IF(AND([QA Assigned To]@row = "Bill", OR(STATUS@row = "QA", STATUS@row = "FIELDED")), 1)
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives