How do I combine these expressions?

I have these 2 expressions that each work independently but I can't figure out how to combine them into a single valid if expression

SELECT(T Sheets Export[Timesheet ID], [Contract/TM]=[_THISROW].[Type],
[TYPE]<>"Shop Maintenance"),

T Sheets Export[Timesheet ID]-Ticket details[tsheets id]-SPLIT(Ticket details[tsheets id enum] ,",")

This expression creates this error and references an IN function which isn't in the expression:

Column Name 'Tsheets ID Enum' in Schema 'Ticket Details_Schema' of Column Type 'EnumList' has an invalid data validation constraint '=SELECT(T Sheets Export[Timesheet ID], [Contract/TM]=[_THISROW].[Type], [TYPE]<>"Shop Maintenance"), T Sheets Export[Timesheet ID]-Ticket details[tsheets id]-SPLIT(Ticket details[tsheets id enum] ,",")'. IN function is used incorrectly

When I try combining with an AND Statement, I receive an error that states it must be a yes/no condition

AND(
SELECT(T Sheets Export[Timesheet ID], [Contract/TM]=[_THISROW].[Type],
[TYPE]<>"Shop Maintenance"),

T Sheets Export[Timesheet ID]-Ticket details[tsheets id]-SPLIT(Ticket details[tsheets id enum] ,",")
)

Error:

Condition AND(SELECT(T Sheets Export[Timesheet ID],([Contract/TM] = [_THISROW].[Type]),([TYPE] <> "Shop Maintenance")), ((T Sheets Export[Timesheet ID]-Ticket Details[TSheets Id])-SPLIT(Ticket Details[Tsheets ID Enum],","))) has an invalid structure: subexpressions must be Yes/No conditions

0 5 389
5 REPLIES 5
Top Labels in this Space