This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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...
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...
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...
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 ...
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...
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")
