Skip to content

Instantly share code, notes, and snippets.

@amitastreait

amitastreait/gist:2c21cf707427c45c1ec83e723f07391f

Last active August 9, 2023 05:31
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save amitastreait/2c21cf707427c45c1ec83e723f07391f to your computer and use it in GitHub Desktop.
Save amitastreait/2c21cf707427c45c1ec83e723f07391f to your computer and use it in GitHub Desktop.
Download ZIP
Department formula
Raw
gistfile1.txt
IF(
TEXT( Department__c )="IT",
IMAGE("https://www.vecteezy.com/vector-art/5928014-it-logo-design-for-information-technology-company-logo-design-vector", "Information Technology", 200, 200) ,
IF(
TEXT( Department__c )="CSE",
IMAGE("https://technext.ng/wp-content/uploads/2020/01/photo-1498050108023-c5249f4df085.jpeg", "Computer Science", 200, 200),
IF(
TEXT( Department__c )="EX",
IMAGE("https://www.dreamstime.com/initial-letter-ex-logo-template-design-initial-letter-ex-logo-template-design-image138107034", "EX", 200, 200),
IF(
TEXT( Department__c )="ECE",
IMAGE("https://manavrachna.edu.in/wp-content/uploads/2021/06/Electronics-and-Communication-Engineering-ECE.jpg", "ECE", 200, 200),
IF(
TEXT( Department__c )="CE",
IMAGE("https://leverageedu.com/blog/wp-content/uploads/2020/07/PhD-in-Civil-Engineering.png", "CE", 200, 200),
IF(
TEXT( Department__c )="ME",
IMAGE("https://images.shiksha.com/mediadata/images/articles/1603459419phpnznMVF.png", "ME", 200, 200),
IF(
TEXT( Department__c )="Autombile",
IMAGE("https://autotronics.sseauto.in/wp-content/uploads/2016/05/shutterstock_124876684.jpg", "Autombile", 200, 200),
IF(
TEXT( Department__c )="Biotechnical",
IMAGE("https://img.freepik.com/free-vector/gradient-hub-logo-template_23-2149845600.jpg", "Biotechnical", 200, 200),
IF(
TEXT( Department__c )="Chemical",
IMAGE("https://www.dreamstime.com/letter-c-chemical-logo-design-simple-unique-image239958601", "Chemical", 200, 200)
, ""
)
)
)
)
)
)
)
)
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment