Kleerfyre✭✭✭✭✭✭

Glad I could help!

Try testing out each part of your formula to see what part is throwing it off. Break it down piece by piece and you should find the issue.

The @cell part at the end is wrong. It will need to be @cell = "Color Add", but in doing that, you will need to adjust your NOT(CONTAINS part. Try replacing it with NOT(@cell = "Color Add")

You don't have enough ) for all your (. Go back through your formula and make sure you match them all up. Without anymore context, I don't know what else to look at. What are you trying to do with your formula?

Try removing the ( in front of IFERROR. You have a lot going on in this formula so fixing that might open up more errors.

Each user that has access should be able to create their own filters that will not affect anyone else.

I don't think this formula will work, but you can try it. It is Nick's with an adjustment. =IF(AND([LTC Intro Meeting Complete]@row = "Yes", [LTC Quote / Proposal Issued]@row = "Yes"), 1, IF(AND([LTC Intro Meeting Complete]@row = "Yes", [LTC Quote / Proposal Issued]@row = "No"), 0.5, IF(AND(OR([LTC Intro Meeting…

它会be the AND statements and the OR statements where your issue is coming from. Let me look at these two formulas again and I will figure it out. I have some similar formulas that might be able to be adjusted to fit your use case.

And you can try this formula and see if it works for you: =COUNTIFS({Comments Log Range 1}, [Document Name]@row, {Comments Log Range 2}, OR(@cell = "Intermediate", @cell = "Preliminary Draft", @cell = "Final"),{Comments Log Range 4}, "Open")

So I have a formula that I can re-work that will help you in this situation, but you might be getting the error error due to the first part of your formula. Is there a match of what you have in the Document[email protected]in the formula sheet that matches what you have in the Comments Log Range 1 reference of the other sheet.…