Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

IF statements with numbers and time

Topic Labels: Base design
Solved
Jump to Solution
980 3
cancel
Showing results for 
Search instead for 
Did you mean: 
VedranN
4 - Data Explorer
4 - Data Explorer

Hi everybody,

if I can ask for help with formulas in IF statements

I 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  

 

 

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

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"
)

Screenshot 2024-04-17 at 5.29.14 PM.png

See Solution in Thread

3 Replies 3
TheTimeSavingCo
18 - Pluto
18 - Pluto

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"
)

Screenshot 2024-04-17 at 5.29.14 PM.png

Thank you very very much, it works 🙂

 

Alexey_Gusev
13 - Mars
13 - Mars

Funny example of 'when you code is a mess, but it works  🤣',
I would not recommend it to use in real life

Alexey_Gusev_0-1713351065152.png