Cannot Compare List with Text

AppSheet AppSheet Q&A
, ,
1 
FILTER("PUTAWAY DETAILS",

IFS([_THISROW].[SELECT TYPES]=Generate Daily Report,
AND([ENTRY DATE]>=[Repack Date],[STICKER COMPLETE DATE]<=[Sticker Date])
,

[_THISROW].[SELECT TYPES]=Download Sticker Person Report,
[STICKER PERSON]=[_THISROW].[Sticker Person Name],

[_THISROW].[SELECT TYPES]=Download Table Person Report,
[TABLE PERSON NAME]=[_THISROW].[Repack Person Name],

[_THISROW].[SELECT TYPES]=By Date and Sicker Person,
AND([STICKER COMPLETE DATE]>=[Sticker Date],[STICKER COMPLETE DATE]<=[Sticker Date],[Sticker Date]=[_THISROW].[Sticker Person Name]),

[_THISROW].[SELECT TYPES]=By Date and Table Person,
AND([ENTRY DATE]>=[Repack Date],[ENTRY DATE]<=[Repack Date],[TABLE PERSON NAME]=[_THISROW].[Repack Person Name]),

[_THISROW].[SELECT TYPES]=Default Data,TRUE

)
)

Cannot compare List with Text in ([TABLE PERSON NAME] = [_THISROW].[Repack Person Name])

Tell me what’s wrong with it.

2

Hi @Sirfyaad

You may want to try the search bar:

https://www.googlecloudcommunity.com/gc/forums/searchpage/tab/message?advanced=false&allow_punctuation=false&filter=location&location=category:appsheet&q=Cannot%20Compare%20List%20with%20Text

Aurelien_0-1680709971902.png
Aurelien_0-1680709971902.png709Ă—911 34.3 KB

3

How to apply in() function inside it.

@Aurelien

4

Hi @Sirfyaad

IN() - AppSheet Help

5

How can I use inside this function? Please help @Aurelien

6
  1. can you try using quote marks?
FILTER("PUTAWAY DETAILS",
  IFS([_THISROW].[SELECT TYPES]="Generate Daily Report",
    AND(
        [ENTRY DATE]>=[Repack Date],
        [STICKER COMPLETE DATE]<=[Sticker Date]
    ),
    
    [_THISROW].[SELECT TYPES]="Download Sticker Person Report",
    [STICKER PERSON]=[_THISROW].[Sticker Person Name],

    [_THISROW].[SELECT TYPES]="Download Table Person Report",
    [TABLE PERSON NAME]=[_THISROW].[Repack Person Name],

    [_THISROW].[SELECT TYPES]="By Date and Sicker Person",
    AND(
        [STICKER COMPLETE DATE]>=[Sticker Date],
        [STICKER COMPLETE DATE]<=[Sticker Date],
        [Sticker Date]=[_THISROW].[Sticker Person Name]
    ),

    [_THISROW].[SELECT TYPES]="By Date and Table Person",
    AND(
        [ENTRY DATE]>=[Repack Date],
        [ENTRY DATE]<=[Repack Date],
        [TABLE PERSON NAME]=[_THISROW].[Repack Person Name]
    ),
    [_THISROW].[SELECT TYPES]="Default Data",
    TRUE
)
)
  1. [SELECT TYPES] is an Enumlist?

Then you may want to change the previous expression and try some things like:

FILTER("PUTAWAY DETAILS",
  IFS(CONTAINS([_THISROW].[SELECT TYPES],"Generate Daily Report"),
    AND(
        [ENTRY DATE]>=[Repack Date],
        [STICKER COMPLETE DATE]<=[Sticker Date]
    ),
    
    CONTAINS([_THISROW].[SELECT TYPES],"Download Sticker Person Report"),
    [STICKER PERSON]=[_THISROW].[Sticker Person Name],

    CONTAINS([_THISROW].[SELECT TYPES],"Download Table Person Report"),
    [TABLE PERSON NAME]=[_THISROW].[Repack Person Name],

    CONTAINS([_THISROW].[SELECT TYPES],"By Date and Sicker Person"),
    AND(
        [STICKER COMPLETE DATE]>=[Sticker Date],
        [STICKER COMPLETE DATE]<=[Sticker Date],
        [Sticker Date]=[_THISROW].[Sticker Person Name]
    ),

    CONTAINS([_THISROW].[SELECT TYPES],"By Date and Table Person"),
    AND(
        [ENTRY DATE]>=[Repack Date],
        [ENTRY DATE]<=[Repack Date],
        [TABLE PERSON NAME]=[_THISROW].[Repack Person Name]
    ),
    CONTAINS([_THISROW].[SELECT TYPES],"Default Data"),
    TRUE
)
)

EDIT

  1. [SELECT TYPES] is a List?

If so, expression with CONTAINS would turn into:

IN("yourText", [_THISROW].[SELECT TYPES])

For reference:

CONTAINS() - AppSheet Help

IN() - AppSheet Help

7

Thank you very much for giving your valuable time. I will definitely reply you again after testing it.

8

how to add this function inside it.

9

@Sirfyaad

I help you, but you must make an effort.

Read the documentation. Read my posts in this thread. Make tries.

10

Still showing the same error. which was showing earlier. @Aurelien

[select Types] is a Enum

11

Did you try this one?

1 Like
12 
Cannot compare List with Text in ([TABLE PERSON NAME] = [_THISROW].[Repack Person Name])

This is the error. The Table Person Name or Repack Person Name is a List or EnumList. You should use IN() or CONTAINS()

1 Like
13

Thnx you for your support :folded_hands: