IF statements with numbers and time

Question

Hi everybody,if I can ask for help with formulas in IF statementsI have developed Glide app with Airtable, works really good.I have a table WorkOrders, and among other columns, I have:"Start time", "Start kilometers", "End Time", "End kilometers", "Total km", "Total time", "Status".This formula is in column "Status", works good:IF(OR({NameSurname}="",{Startkm}=""),"CREATED",IF({Endkm}="","IN PROCESS",IF({Endkm}>{Startkm},"COMPLETED")))How can I add another Status, Canceled?Button CANCEL in Glide updates the fields: Startkm and Endkm to 0 (zero), StartTime and EndTime to CurrentTime (same data in StartTime and EndTime)Can you help me with the formula?Thank you very much

TheTimeSavingCo · Accepted Answer

Hm, personally I'd split it out like this as it's easier for me to look at:

IF(
  AND(
    Startkm="",
    Endkm="",
    Startkm != "0",
    Endkm != "0"
  ),
  "CREATED"
) &
IF(
  AND(
    NameSurname,
    Startkm,
    Endkm=""
  ),
  "IN PROCESS"
) &
IF(
  AND(
    Endkm > Startkm,
    NameSurname
  ),
  "COMPLETED"
) &
IF(
  AND(
    NameSurname,
    Startkm = "0",
    Endkm = "0"
  ),
  "CANCELED"
)

Thank you very very much, it works 🙂

VedranN · Answer

Hm, personally I'd split it out like this as it's easier for me to look at:

IF(
  AND(
    Startkm="",
    Endkm="",
    Startkm != "0",
    Endkm != "0"
  ),
  "CREATED"
) &
IF(
  AND(
    NameSurname,
    Startkm,
    Endkm=""
  ),
  "IN PROCESS"
) &
IF(
  AND(
    Endkm > Startkm,
    NameSurname
  ),
  "COMPLETED"
) &
IF(
  AND(
    NameSurname,
    Startkm = "0",
    Endkm = "0"
  ),
  "CANCELED"
)

Thank you very very much, it works 🙂

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded