Cannot Compare List with Text

[Sirfyaad]

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.

[Aurelien]

Hi @Sirfyaad 

You may want to try the search bar:

https://www.googlecloudcommunity.com/gc/forums/searchpage/tab/message?advanced=false&allow_punctuati...

[Sirfyaad]

How to apply in() function inside it. 

@Aurelien  

[Aurelien]

Hi @Sirfyaad 

IN() - AppSheet Help

[Sirfyaad]

---

@Sirfyaad wrote:

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 )

---

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

[Aurelien]

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
)
)

 2) [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

3)  [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

[Sirfyaad]

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

[Sirfyaad]

---

@Aurelien wrote:

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

---

how to add this function inside it.

[Aurelien]

@Sirfyaad 

I help you, but you must make an effort.

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

[Sirfyaad]

---

@Aurelien wrote:

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 ) )

---

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

[select Types] is a Enum

[Aurelien · Accepted solution]

Did you try this one?

---

@Aurelien wrote:

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
)
)

---

[Sirfyaad]

Thnx you for your support 🙏

[JuneCorpuz]

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()