IF this than formula for multiple cells

Hello!

Trying to create a formula to notate when 1 of 4 columns has text in it. For a project to be “complete” there needs to be date in either column A, B, C or D. I would love a column that would give me a check mark for it.

Thanks,
Eileen

Try this formula:
IF(OR({Date Field A}, {Date Field B}, {Date Field C}, {Date Field D}),'✔')

3 Likes

Hummmm, still not working…
IF(OR({Media Central Link (Desktop)},{Media Central Link (Mobile)},{Content Grid Link (Desktop)},{Content Grid Link (Mobile)},‘:heavy_check_mark:’))

Next-to-last parenthesis in wrong spot. You want to close out your “OR” before moving on in IF statement

IF(OR({Media Central Link (Desktop)},{Media Central Link (Mobile)},{Content Grid Link (Desktop)},{Content Grid Link (Mobile)}),‘:heavy_check_mark:’)

2 Likes

Sill no luck!

11%20AM

Sorry, didn’t look through the whole thing and just saw the bracket issue. The other problem is the single quotes around your check mark. if you swap those for double quotes it should work. I tested in a dummy base and it looks good.

IF(OR({Media Central Link (Desktop)},{Media Central Link (Mobile)},{Content Grid Link (Desktop)},{Content Grid Link (Mobile)}),“:heavy_check_mark:︎”)

@Eileen_Ann_Cain & @Btbml

In Airtable, it doesn’t matter if you’re using single quotes or double quotes, the problem is straight quote (' or ") versus curly (‘or ”). You have to uses straight quotes in Airtable formulas or they won’t work. Notice how my original formula suggestion uses straight quotes, but all subsequent formulas in the thread use curly.

Your formula would be:

IF(OR({Media Central Link (Desktop)},{Media Central Link (Mobile)},{Content Grid Link (Desktop)},{Content Grid Link (Mobile)}),'✔')

2 Likes

Thanks @Kamille_Parks, I was wondering about this because I was positive I had used single quotes before. The issue was the formatting on this forum and copy/pasting that.

1 Like

Amazing! That you both so much!