if formula question

Baek

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.JPG I_Approval Status blue.JPG I_Approval Status error.JPG

I need your help... please help me

Accepted answers

Sai_Bharadwaj_Venati

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/

kevin.cho

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.

All comments

Sai_Bharadwaj_Venati

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/

kevin.cho

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.

ManjunathKN

Hi @Baek

you can code something like this

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

Thanks,
Manjunath

Baek

Hi,

Thank you for answer
it really helped!

Have a wonderful week ahead!

Baek

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!!!

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…