Discussions

Expand all | Collapse all

Auto populate dates

  • 1.  Auto populate dates

    Posted 05-07-2018 20:55
    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. 


  • 2.  RE: Auto populate dates

    Posted 05-07-2018 21:05
    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.


  • 3.  RE: Auto populate dates

    Posted 05-17-2018 12:46
    Thank you Matthew. 

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