1

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.

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

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

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:

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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