Help

Re: IF this than formula for multiple cells

1633 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Eileen_Ann_Cain
5 - Automation Enthusiast
5 - Automation Enthusiast

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

8 Replies 8

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

Eileen_Ann_Cain
5 - Automation Enthusiast
5 - Automation Enthusiast

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: ’))
Screen Shot 2019-10-25 at 5.48.52 PM.png

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: ’)

Eileen_Ann_Cain
5 - Automation Enthusiast
5 - Automation Enthusiast

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)}),'✔')

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.

Eileen_Ann_Cain
5 - Automation Enthusiast
5 - Automation Enthusiast

Amazing! That you both so much!