Problem with if isblank

[Martina_Hawkins]

I have a column called Status. I am using formula below but it is not working.
I have tried putting it in initial Value and in App Formula but neither works. Any idea what I am doing wrong?

IF(ISBLANK([Order No]), “Requested”, “Ordered”)

[Martina_Hawkins]

Figured out that this works when I add a new record but doesn’t update already existing records.

[LeventK]

@Martina
Set the RESET ON EDIT property to ON and write a conditional expression to trigger the resetting of your initial value i.e.

ISNOTBLANK([Order No])

When this expression evals to TRUE, the initial value of the existing record will be resetted and the expression in your initial value will be re-computed.

[Martina_Hawkins]

thanks but where do I put the conditional expression. Image below sets Status field to True or False?

[LeventK]

@Martina
Click on the blue funnel icon to open the expression editor. Write down your expression and save it. That’s all.

[Martina_Hawkins]

Got it working! Thanks for all your help.