How to stop calculation

Highlighted
New Contributor

Greeting to All,

 

I want your help in the below issue,

 

I have a calculation of days to know how many days the work is open , and other column for the status, I need to stop the days. Calculation once I change the status to completed.

c

3 Replies
Highlighted

@iAbdullah1180 

 

Hi

 

Can you use IF like this?

 

IF(Status="Complete","",perform calculation)

 

Peter

Highlighted

@peteryac60 

 

Thank you a lot the issue solved as you say 

I appreciate your help..

Highlighted

@iAbdullah1180 

 

you are welcome.

 

please mark this as best solution for others to benefit.

 

thanks!