I am trying to generate column called
status_mode which should have the outputs
DELAYED. But I am comparing two columns one is
DATE REQUESTED and other is
FAD_CODE. Below is my formulae.
Conditions i am applying.
- If FAD_CODE field is blank it should show Pending
- If FAD_CODE got value it should show DONE
- If FAD_CODE field is blank for three days it should show DELAYED