This is my first day using SharePoint and I got lost in trying to figure out how or if it can be done, custom column calculations, and if code is allowed in SharePoint? I had someone else create my own site and I have been in the entire thing all day and its exciting!
I figured I would be doing a lot on my own so I created a custom list. I am wanting to do the following:
- Column A: Add the date you wish
- Column B: Would take the actual date and calculate how many days from the added date in Column A
- Column C: Will enter the closed date that will stop the counter in Column B
In general I am creating a ticket system in SharePoint, but I don't know if it can be done or where to look for it.
Edit: Example of what I am looking for
Date: Days Closed 2/19/2013 0 Days
If a closed date is entered tomorrow
Date: Days Closed 2/19/2013 1 Days 2/20/2013
Incremental for days will end. If a date is not entered in the close column the days will keep adding.