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! Go to 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"),"...
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!
User | Count |
---|---|
18 | |
11 | |
11 | |
8 | |
4 |