IFS function is used incorrectly:Inputs to IFS() must be condition-value pairs. Input 4 is not a value of a consistent type

IFS(
HOUR([Total Hours]) >= 8,“08:00:00”,
TRUE,[Total Hours]
)

I get this error on the above formula

“IFS function is used incorrectly:Inputs to IFS() must be condition-value pairs. Input 4 is not a value of a consistent type.”

Solved Solved
0 1 1,128
1 ACCEPTED SOLUTION

It sounds that [Total Hours] is a duration and “08:00:00” is a time.

View solution in original post

1 REPLY 1

It sounds that [Total Hours] is a duration and “08:00:00” is a time.

Top Labels in this Space