If Than Formula

[Erik_Andersson1]

I am having difficulty creating the following formula based on not fully understanding if than statements.

I have a column that shows total moving time. This is triggered by a button, that is initiated by a delivery.

Once the date is filled out, I want the status to change from (x) to (y). What would the best way to create this.

I believe this is fairly simple but can’t get the right formula set up.

[Jannis]

Hi @Erik_Andersson1,

please take a look if that is what you need: https://coda.io/d/_dIG5nG7H9fU/https-community-coda-io-t-if-than-formula-42857_suDyd

If not, i would appreciate it if you could share a copy of your doc.

Sincerely
Jannis

[Erik_Andersson1]

Thanks Janis, I got this figured out.