Jan 06 2023 11:10 AM - edited Jan 06 2023 01:14 PM
I have what should be a very simple need, but I can't find any input anywhere that actually works as purported.
I want to set a default value (not a calculated column) for the Title of a list item, utilizing elements of the date and time. I would like the title, for example to be "230106 1402" if the item were created on "January 6, 2023, 2:02pm." I have no problem getting the date using TODAY function ("=TEXT(Today,"yymmdd""), but I can't get NOW to work in any way whatsoever.
The most I've been able to do is create a Date column with the default value of =VALUE(NOW()), and I have no idea what to do with that. I tried using it wrapped in the TEXT function as part of the Default for the Title, but SharePoint didn't like whatever I tried.
This should be SO SIMPLE...
Jan 06 2023 01:27 PM