Starting View time-dependent

Morning, I would like the view of the app to change based on the time.
The formula I had thought of: IF(TIMENOW()>(Addetti[Ora Servizio]+"008:00:00"),"Menu","In Turno"), gives me this error: Arithmetic expression '(Addetti[Ora Servizio]+"08:00:00")' has inputs of an invalid type 'Unknown'

Suggestions?

Thanks in advance

Solved Solved
0 3 118
1 ACCEPTED SOLUTION

You are trying to sum list and duration, which of course doesn't work, and that's why this error. If you have only one row in that table, you could write it like..

IF(TIMENOW()>(ANY(Addetti[Ora Servizio])+"008:00:00"),"...

View solution in original post

3 REPLIES 3

You are trying to sum list and duration, which of course doesn't work, and that's why this error. If you have only one row in that table, you could write it like..

IF(TIMENOW()>(ANY(Addetti[Ora Servizio])+"008:00:00"),"...

@AleksiAlkio ๐Ÿ™

Thanks a lot 

You're welcome!

Top Labels in this Space