Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to create a button or buttons (open to other options) to show items that have a Sign Off Date vs. items that do not have a Sign Off Date. The Sign Off Date field just has dates in each cell or a "-". Looking for some suggestions/assistance on how to do this.
Thanks in advance!
Your data may like this:
Item, SignoffDate
1, 8/1/18
2, -
3, 7/15/18
4, 7/14/18
5, 7/12/18
6, -
Try Expression like this:
Button - Actions - Add - Select possible - Field - Count({<SignoffDate=>}Item) & 'vs' & Count({<SignoffDate = {''}>}Item).