About Genki_Tokyo

Genki_Tokyo · 11-03-2023

I'm sorry if it's hard to understand because I'm translating the question from Japanese into English using translation software. IFS( AND([ColumnA]<>"",[ColumnB]=""),[ColumnA].[ColumnC], //conditions1 AND([ColumnB]<>"",[ColumnA]=""),[ColumnB].[Column...

Genki_Tokyo · 10-17-2023

I'm sorry if it's hard to understand because I'm translating the question from Japanese into English using translation software.If there is an input in "Column A", I would like to restrict it from being entered in "Column B".Please tell me how to set...

Genki_Tokyo · 10-12-2023

I'm sorry if it's hard to understand because I'm translating the question from Japanese into English using translation software.I would like to manage the rental of mobile phones.Multiple units may be rented.I want to display "Phone1" and "Phone2" in...

Genki_Tokyo · 10-09-2023

■現状列の種類：参照推奨値：ORDERBY( select(City_Table[id_City],[country_name]=[_thisrow].[country_name]), [id_City],false)参照された値は、仮想列の [City_name] として使用されます。■こんなことをしたい列の種類：テキスト希望の値：City_Table[City_name]条件：[国名]=[_thisrow].[国名]並べ替え：都市_テーブル[id_都市] 翻訳ソフトを使って質問を日本語から英...

Genki_Tokyo · 10-05-2023

I want to set permissions that are not in the default.The default expression is:SWITCH(USEREMAIL(),“user1@mydomain.com”, “UPDATES_ONLY”,“user2@mydomain.com”, “ALL_CHANGES”,“READ_ONLY”)“Add and update”“ALL_CHANGES” allows it to be deleted, so I don’t ...

Genki_Tokyo · 11-06-2023

It is just like you said 

Genki_Tokyo · 11-06-2023

i did it!!I solved it with this.IFS(AND((ISNOTBLANK([ColumnA]),ISBLANK([ColumnB])),"1st result",AND((ISNOTBLANK([ColumnB]),ISBLANK([ColumnA])),"2nd result",AND((ISNOTBLANK([ColumnA]),(ISNOTBLANK([ColumnB])),"3rd result")It's a tedious task, but I'm O...

Genki_Tokyo · 11-06-2023

Thank you for checking.That's usually the case.I will verify if there is a problem with "ref". thank you very so much.

Genki_Tokyo · 11-05-2023

It will be like thisIFS(AND([ColumnA]<>"",[ColumnB]=""),"1st result", →"3rd result"AND([ColumnB]<>"",[ColumnA]=""),"2nd result", →"2nd result"AND([ColumnA]<>"",[ColumnB]<>""),"3rd result" →"3rd result")

Genki_Tokyo · 11-05-2023

[ColumnA]、[ColumnB] is Ref The conditional expression "AND([ColumnB]<>"",[ColumnA]="")" reacts correctly.

My Stats

akhilgupta81's Bio

Badges Genki_Tokyo Earned

Recent Activity

“IFS” does not process correctly

About input restrictions

ER_Relationships

How to use "ORDERBY" when "Column_Type" is "Text"?

"Are updates allowed?"

Re: “IFS” does not process correctly

Re: “IFS” does not process correctly

Re: “IFS” does not process correctly

Re: “IFS” does not process correctly

Re: “IFS” does not process correctly