if formula question

Hi

I'm trying to make formula but it's not going well

 

IF ステータス = 承認済み THEN TRUE ELSE FALSE

 

how can i make this formula?

 

I_Approval Status.JPGI_Approval Status blue.JPGI_Approval Status error.JPG

I need your help... please help me

Tagged:

Best Answers

  • Hey,

     

    Don't know the language, but understood something 

     

    I guess formula should be like

     

     IF name(List formatted line item) = "alert text" THEN TRUE ELSE FALSE or it can be 

     IF name(List formatted line item) = Line item [Remove name if it's Line item is list format] THEN TRUE ELSE FALSE

     

    You can write formula little better => name(List formatted line item) = "alert text" [No need of use for IF Else condition in this case]

     

     

    Thanks & Regards,

    Sai Bharadwaj

    https://www.linkedin.com/in/sai-bharadwaj-venati/

     

    V.Sai Bharadwaj

    Connect on LinkedIn

  • kevin.cho
    Answer ✓

    Hi @Baek 

     

    You need to ensure you're comparing the same data types in your equality. 

     

    The line item ステータス is formatted as S_Status, so the right hand side of your equation "承認済み" needs to also be a list formatted line item or value. 

     

    If 承認済み is an item in S_Status, then it would need to be rewritten as:

     

    ステータス = 'S_Status'.承認済み

     

    As @Sai_Bharadwaj_Venati also said, rather than doing the 

    IF ステータス = 'S_Status'.承認済み THEN TRUE ELSE FALSE

     

    You can just leave it as:

    ステータス = 'S_Status'.承認済み

     Since if this is TRUE, then it will return TRUE, and if it's false it will return FALSE.

Answers

  • Hi @Baek 

    you can code something like this

    Name(ステータス)= "承認済み"

    Thanks,
    Manjunath

  •  

    Hi,  

     

    Thank you for answer
    it really helped!


    Have a wonderful week ahead!

  • Hi,
    Thank you for answer!
    you are a genius.
    Thanks for your help in solving this problem.
    I will never forget what I learned.
    Have a nice day!!!