Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
i have a list box with repeated values (specifically dates in format "DD/MM/YYYY") and i would like to "aggregate" them and see only one record if the value is the same, is there any way to do it?
Here's what i have now:
Here's what i would like to see:
Giorno pubblicazione flusso
08/02/2016
07/02/2016
06/02/2016
...
Thank in advance,
Andrea
Its is important to use Sunny T's script to remove the time portion. The format you are using hides the time differences, so they appear the same in the listbox.
NOTE Date(.., 'dd/MM/yyyy') does NOT remove the time portion, it merely changes the display format. You must have a Floor() in the expression.
Hi Andrea,
Will it be possible to share the app ? so it will be easy for us to help.
Regards
KC
Try this as your list box expression:
=Date(Floor([Giorno pubblicazione flusso]))
Hi Sunny,
did i insert the code in the right place?
With this configuration the risult is "-" in the listbox for every date but maybe i did something wrong.
I'm afraid the sharing function is disabled by the admin too because i'm working on custom sheet part of a non-editable common document...
Thank you all for help and patience too.
Andrea
Try doing it like this:
Also what is the name of the field? Doesn't seem to be -> Giorno pubblicazione flusso
You will need to put the field name that originally comes from the script.
Got it! Thank you very much Sunny! And thanks to all the other users for your advices too.
Andrea
You need to thank Rob
I just proposed minor alternations
Awesome
I am glad we all were able to help you in one way or the other.
Best,
Sunny