Last Updated by - amend so only picks up when the task is changed to complete

[CharlieHa3]

I've added Last Updated by to my view but i want to change this so it only picks up when the task is changed to complete. ie when it's changed to In progress or an Update is added for the task the Last Updated field is blank but when it's changed to Complete the field has the name of the person who did this. Is this possible?

[lgaertner]

Hello Charlie,

One approach could be the following:

valueexpression=valueexpression=IF({status}="CPL",{lastUpdatedBy}.{name},"")
textmode=true
valueformat=HTML
displayname=completed by

alternatively you could also use the following valueexpression:

IF({percentComplete}=100,{lastUpdatedBy}.{name},"")

But on the other hand I would be careful with this, as the field lastUpdatedById will be changed with any modification on that task.

So, if someone changes anything else, but the status / percentage, you could run the risk of having the wrong person displayed here.

Regards

Lars

[Doug_Den_Hoed__AtAppStore]

Hi @CharlieHa3,

Further to the drawbacks @lgaertner mentioned, I invite you to consider avoiding them by using my Targeted Auditing technique.

Regards,

Doug

[CharlieHa3]

Thanks Doug - i'll give this a try

[CharlieHa3]

thanks Lars. I couldn't get this to work first time I tried but I'll play around with it.