IF Formula - Checked Community and Can't Find a Solve

JWG312

It will not return the N/A. I removed the quotes around N/A, added them in and it won't give me the result either way. I removed the Dropdown function on the GF Testing Required and made it to a Text/Number format but it will not return the "No" in the Form- Approved column. The formula works in Excel with the N/A in quotes so not sure why it won't work in Smartsheet

Nic Larsen

You should just need quotes around both.

="No", "N/A")

JWG312

Hi @Nic Larsen thank you, should have mentioned that I tried that too and it didn't work originally

Nic Larsen

Is it working now? What column type are you entering the formula into? It should also be a text/number column. I'd maybe try clearing out your formula and retyping it. If the Column Name in the formula isn't a different color than the rest, it likely isn't picking up your column name which can happen in a copy paste situation.

JWG312

@Nic Larsen No, it doesn't work still, I am entering it into a text/number column and it's coming from a text/number column. And not a copy paste so still wondering why the formula won't work.

Nic Larsen

In your screenshot, it looks like the formula is all a single color which tells me it is not properly referencing your column… in my test sheet below, the column is showing as blue in the formula. If yours is not showing a color, try retyping it and selecting the column again.

JWG312

I just tried again to match yours with the color and still blank

Nic Larsen

That all looks correct. I'm stumped. No reason it shouldn't be working.

Can you add a "False" after the "N/A", so we can see if it gives a response to that.

dojones

The formula is missing an argument. Try this.

=IF([GF Testing Required]@row = "No", "No", "N/A")

JWG312

@dojones thank you, just tried it and nothing populates in the cell, truly strange why it won't work

dojones

Check the column type is text/number for both columns. If both text/number, for debug purposes, insert a column next to it and populate some sample data. Reference the formula to that column to see if it works. Maybe there is something unusual about the original column. If that works, I would just copy the data to the new column, delete the old column, and see if that fixed it.