Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

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

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

Hi Every one i want a formula like this:
IF({TaskIcon} == BLANK(),“https://png.pngtree.com/png-clipart/20191120/original/pngtree-pen-icon-isolated-design-png-image_504...”)
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
Nick_Dennis
7 - App Architect
7 - App Architect

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

IF(TaskIcon = BLANK(), "https://png.pngtree.com/png-clipart/20191120/original/pngtree-pen-icon-isolated-design-png-image_5045590.jpg")

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