How to make a conditional formula ?

[pthathes]

Hi Team,

I need to update the status like completed , inprogress & Cancelled, base on the below.

Condition 1    ->   A and B are "null" , then status should be "inprogress"

Condition 2    ->   A is null B contains date, then status should be "cancelled"

Condition 3    ->   A contains numeric value and B contains the Date, then status should be "Completed"

A	B	Status should be
8732	01/10/2024 04:12:14 AM	completed
null	null	Inprogress
8810	01/24/2024 11:33:29 AM	completed
null	01/24/2024 12:52:25 PM	Cancelled
52210	01/25/2024 11:24:46 AM	completed
52223	01/30/2024 07:26:55 AM	completed
null	null	Inprogress
8872	02/01/2024 09:29:17 AM	completed
null	02/12/2024 05:51:38 AM	Cancelled
52253	02/12/2024 05:52:25 AM	completed
null	02/12/2024 05:53:32 AM	Cancelled
null	null	Inprogress
52250	02/12/2024 05:55:14 AM	completed

Thanks

Thathes

[ShankerV]

Hi @pthathes 

The below will work for your use case.

IF isnull([ARTICLE NUMBER]) and isnull([COMPLETED])

THEN 'Inprogress'

ELSEIF isnull([ARTICLE NUMBER])

THEN 'Cancelled'

ELSE 'Completed'

ENDIF

 

Many thanks

Shanker V

[pthathes]

Thank you so much Shankar V...

Its working fine...

Regards

P. Thathes