Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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