nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Recommended Design for Determining Whether a Source Combination Exists in a Target List
Hello Anaplanners, I'm looking for advice on the best modeling approach for a DCA use case. Scenario I have an input module called "CC-Account Activation". It is dimensioned by: Cost Center (CC) Account Users can select an Activate? boolean to indicate that a Cost Center / Account combination should be activated. I have a…
Anaplan XL Forms Error
Does anyone also get this error when opening the Forms in Anaplan FCR? I am downloading Investment Registry from the app but I cannot open it in Anaplan XL. How did you fix this issue?
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…