Hi, need help

General
,
1

Hello, I need a formula that checks if there are any events available for the current day. If there are any events, I want it to return NEVER. If there are NO events for the current day, I want it to return ALWAYS. Thanks.

2

You can try something like this:

$if (ci(ecount, a0d) > 0, NEVER, ALWAYS)$

2 Likes
3

@Alex1 , @Ace :

If I may add…

I would suggest the following code snippet.

$if(
  ci(ecount, a0d)>0 &
  ci(acount, a0d)>0,
  NEVER, ALWAYS
)$

NOTES

  • $ci(ecount, a0d)$ ➞ ∑ today’s Appointments
  • $ci(acount, a0d)$ ➞ ∑ today’s All Day events

I hope this would help.
:smiling_face::+1:

2 Likes
4

Thanks so much Mr ACE… :100:

5

This topic was automatically closed 25 days after the last reply. New replies are no longer allowed.