I am creating a document library in SharePoint 2013, where I want to have a column which shows the fiscal year (= not the date, only the year). It has to be a choice menu, since people in the beginning are going to upload old documents. However, I would like the default value to be a calculated value, which shows the fiscal year based on the value of the "Created" column. Our fiscal year runs from July to June.
Example: A report is created and uploaded 15th July 2014. Fiscal Year column shows "FY 2015".
So, could someone smarter than me help me with coming up with a nice calculation to solve my problem?
Btw, I am just a basic user of SharePoint, so I don't know how to use SharePoint Designer.
What version of SharePoint do you have? How do you plan to enter the data in your list, using a web part form? – cubanGuy
I am using SharePoint 2013. I'm trying to use a document library which I have added different required columns to so that the users can sort out the documents that affect them and their organization. This library is then used by different users with different views, and they independently upload their documents to the library and enter the data in the required columns.
What I'm asking here is how I automatically in a column can determine the default value of the current fiscal year as a calculated value, since I want the process to be as easy as possible for the users, since there already are so many other columns that they have to fill in.
Please mark Anders' answer as your accepted solution instead of editing your post – Robert Lindgren
For some reason I can't mark the question and accept it? I don't see the check box. (And btw, I can't comment either as you asked me before since I'm a new user and have to have 50 reputation points for that. That's why I have to edit my posts.)