I am working on list of tasks for my team. And met with couple of troubles.
I need to track date of completion and after that its approval. Unfortunately when I have tried to create "completion date" with this formula:
=IF( [Task Status]="Completed" ;DATE( YEAR([Modified on]) ;MONTH([Modified on]) ;DAY([Modified on]) ) )
or another one
=IF( [Task Status]="Completed" ;[Modified on] ;"")
the date will change anytime when someone made any change. Even when approver (manager) approves the task. It automatically changes the completion date to last modifying.
I am getting lost. I've tried InfoPath, do scan of billions chats in internet but without any clever solution. Could someone help with that? How to lock/fixed "completion date" when owner of task change the status to "Completed"?
I am intermediate user of InfoPath, beginner of SP Designer/workflows but loser in any coding (Java, C#,...).
Appreciate any help. Many thanks.