Trying to combine an IF statement and an OR statement and NOT(ISBLANK)

thunt06
thunt06 ✭✭
edited 12/09/19 in Smartsheet Basics

I am trying to utilize an IF statement and an OR statement. I am able to successfully make each statement work independently but when I put them together it doesn't work for me.Β  I am hoping someone can look at each of my statements and see what I am missing.Β  I think I am on the right track but I keep on getting an Error message with each variation. I will also include my examples:

1#Β =IF([1 - ROM Requirements (Status)]4 = "Completed", "100%") This works correctly.

2#Β =IF(NOT(ISBLANK([1 - ROM Requirements (Completed Date)]1)), "100%") This works correctly.

3#Β =IF([1 - ROM Requirements (Status)]2 = "Completed", "100%", OR(NOT(ISBLANK([1 - ROM Requirements (Completed Date)]2, "100%", 0)))Β  This was my attempt at combining them but it only works partially.

I have tried so many variations that I have lost count and can't remember what I have tried.Β  If someone can help get me on the right track again that would be great.

Β 

Thanks

Β 

Β 

Comments