Fields
1 Topic
SP field to allow for entry of year only but set default value to year of item created
Greetings - I am trying to see if it is possible to create a SP library column that would allow for the entry of a 4 digits/characters (to represent Year) but have the default value equal to the year from the items created date. Use case...document library for reports with the request to creating grouping by Year. Generally the Year will equal the Year from the item's created date (when the item was loaded), but there will be instances when previous years reports or end of year reports loaded in the following year (i.e. December 2023 loaded in January 2024) will be added and we will need the ability to override the default value. Am trying to assist with multiple document loading by setting the default value, which will account for the majority of the loads, but need the override option. Looking for advice on: 1. is this even possible? 2. if it is possible, what should the field type be? I have tried starting with text, number and date fields, and utilizing the default value option to be various formula iterations to extract the YEAR from the [Created] date field. In all cases I get either the error that the Default Value is not a number/text or just a general syntax error as it doesn't even like the formula. To overcome the not a number/text value error, I have also tried iterations of converting said result to number/text. Any assistance or further research direction greatly appreciated.Solved2.1KViews1like1Comment