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
User | Count |
---|---|
17 | |
11 | |
7 | |
4 | |
3 |