Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

IF this than formula for multiple cells

Topic Labels: Formulas
951 8
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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.

Amazing! That you both so much!