Expand my Community achievements bar.

The next phase for Workfront Community ideas is coming soon. Learn all about it in our blog!

Calculated field to count the number of times in approval status

Avatar

Level 2

Hi everyone,

I have an issue that I can't solve by myself, so maybe you can help me with your great expertise?

I need to calculate the number of times when Task was sent to Waiting for Approval status. I have a calculated field with formula IF(Status='WFA',SUM(1,Number of Times In Approval),Number of Times In Approval)

It works good, except the cases when I directly change the status from New to Awaiting for Approval. Instead of 1 it shows value 2.

Do you maybe know how I can solve it? Thank you!

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

0 Replies