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.

Improve this question

1 Answer 1

Reset to default
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:

Improve this answer

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.