Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

This is my first day using SharePoint and I was lost in trying to figure out how or if it can be done, custom column calculations, and if code is allowed in SharePoint? I am using SharePoint 2010. 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:

  • ColumnA: Add the date you wish
  • ColumnB: Would take the actual date and calculate how many days from the added date in Column A
  • ColumnC: Will enter the closed date that will stop the counter in ColumnB.

In general I am creating a ticket system in SharePoint, but I dont know if it can be done or where to look for it.

share|improve this question

migrated from stackoverflow.com Feb 22 '13 at 13:59

This question came from our site for professional and enthusiast programmers.

1 Answer 1

Yes, this is possible without code. You will have to use so called "Calculated Columns".

For your date calculations there are even special formulas such as this:

=DATE(YEAR(Column1)+Column2,MONTH(Column1),DAY(Column1))

which actually adds 3 years to the column

There are several examples here:

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.