Is it possible to have an attribute, like start date, where other columns would use it to calculate their value?

For example the due date column would take the start date and then add the amount of date it takes (which is another column) to it.

I eventually would be referencing other tasks for their due date, but that's for another time.

  • What do you mean by attribute like start date? You mean a start date generated by system? – Keerthi Jun 30 '15 at 15:39
  • It would be a start date the project manager would decide/ enter in. – user2337029 Jun 30 '15 at 15:41
  • If the manager is entering in the start date in the form, then a column will be automatically created for that list. What do you need besides that? – Keerthi Jun 30 '15 at 15:44
  • That would mean having a column that would have the same value for each item in the list which seems pointless. The start date would refer to the start date of task list which is the start date of the project, not each task. – user2337029 Jun 30 '15 at 15:51

Maybe you can use another list to store your date in a dummy item. Then read that date from a workflow at creation of the item. Add the number of days you want to the source date and store it in your item.

  • Custom List with a date column
  • Dummy item with reference date
  • SharePoint Designer Workflow on destination list, starts at creation
  • Retrieve reference date from configuration list item
  • Do calculation on reference date to add days and store it to variable
  • Update list item date with variable
| improve this answer | |

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.