Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

IF formula to check if a column is empty then set the value to a column

Topic Labels: Formulas
1166 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi Every one i want a formula like this:
IF({TaskIcon} == BLANK(),“”)
TaskIcon is an Attachment field.
i want that if {TaskIcon} field is blank (No attachment in the field) then my DefaultIcon field set to a url Please Help Someone

2 Replies 2
7 - App Architect
7 - App Architect

You’re very close, I think you just want:

IF(TaskIcon = BLANK(), "")

That will return the specified URL in the formula field is TaskIcon is empty, and it will return nothing if TaskIcon has an attachment.

Thank You so much @Nick_Dennis This works for me!!! Again thanks you