Skip to main content

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

  • October 2, 2020
  • 2 replies
  • 11 views
U
Forum|alt.badge.img

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_5045590.jpg","null”)
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

N
Forum|alt.badge.img+14
  • Nick_Dennis
  • Participating Frequently
  • October 2, 2020

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.

U
Forum|alt.badge.img
  • Usama_Khalid
  • Author
  • New Participant
  • October 2, 2020

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

N
Terms & ConditionsAccessibility statement