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

12_ [COMPLETE GUIDE] Uphold Support Number
At Uphold customer support ⭐+1-888-355-2348 accounts may be temporarily disabled or restricted for various reasons. Raise a concern on priority basis at Uphold support ⭐+1-888-355-2348 if you notice any suspected malicious activity, or a problem during account recovery. To contact Uphold support directly at…
New UX Filtering for Hierarchy sibling
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…