Skip to main content
Topics#TrailheadAmit Gomes's Question
Amit Gomes (Kiwi Routes Limited) asked in #Trailhead
Sep 13, 2021, 5:58 AM

IF Else (Contains) statement on row level with text return

I want to use IF Else Statement on row level to return text value 

IF(CONTAINS(Asset.Name,"0301"),1,0),'EHUBO2.1'

IF(CONTAINS(Asset.Name,"0318"),1,0),'EHUBO2.0'

 

this give me a syntax erorr

Request help .

Kind Regards

Amit 

 

#Trailhead

19 answers
  1. Amit Gomes (Kiwi Routes Limited)
    Sep 13, 2021, 7:35 AM

    Hey Kalpit and Kenji 

     

    IF(CONTAINS(Asset.Name,"0301"),'EHUBO2.1',
    IF(CONTAINS(Asset.Name,"0318"),'EHUBO2.0',
    NULL
    ))

     this one works . 

    but will have more question as i am still learning. 

     

    Thanks

    Amit 

Write an answer...
0/9000