Auto populate dates

  • 0
  • 1
  • Question
  • Updated 6 months ago
  • Answered
I hope to add two fields to my project information, 
"Start Date", equals to Task 1, "Receive Request",  start day, 
"End Date", equals to Task 10, "Send to Client", completed day. 

I set the filed as formula type, but can't find how to link with Task table. Could you give some suggestions? Sorry if I ask the dummy question. Still trying to learn it. Thanks. 
Photo of Ning Li

Ning Li

  • 670 Points 500 badge 2x thumb

Posted 6 months ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
You will want to make a Summary field in the relationship to summarize the Max date where task # = 1, and the max date when task # =10.  

That will give you a good starting point to get used to how to add summaries to date fields.
Photo of Ning Li

Ning Li

  • 670 Points 500 badge 2x thumb
Thank you Matthew. 

It really helps. I create the summary field. It works! Thank you!