Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I am failing to understand why my expression doesn't work here and hope someone can help me.
=If(count(GetFieldSelections([Week Num]))=0,Week(Today())-1,if(count(GetFieldSelections([Week Num]))=1,GetFieldSelections([Week Num]),'-'))
When multiple week numbers are selected [Week Num], it shows the following while i would like to show '-' or N/A (whatever is easier):
That worked! Thank you @Arthur_Fong
Final code if it can help anyone:
=If(GetSelectedCount([Week Num])=0,Week(Today())-1,if(GetSelectedCount([Week Num])=1,GetFieldSelections([Week Num]),'Multiple Selection'))