I have a table where I need to mark when flights take off between 22:00 - 07:00. I would like an If statement where it marks the record with an X when this is true. I have date fields for the departure time but I just cant quite find how to have a ge...
My base is used by salespeople to provide quotes for flights. Sometimes the same trip request is sent to multiple people on my team. I want to eliminate duplicate quotes.
I need a way to notify a salesperson when 5 different fields are the same as a ...
I have a table with many thousands of coordinates. I would like to search these data points by city or state or country but I only have the pairs. Does anyone know whether the Maps app can return such data?
Alternatively, does anyone have any solutio...
I have used this formula to separate data that is simple 4 letter abbreviations and it works perfectly. However, the data is also associated with dates and times that I need to separate and have readable and separate in an email automation. When I us...
Hey kevin! Its kevin, I figured it out for you. Converted the times to decimals.
IF(OR({Departure Time (Airport Time)} < 7.0,
{Departure Time (Airport Time)} > 22.0), ‘x’, BLANK())
So we were using this method and it seemed to have changed a few days ago and now we cant filter it at all. I wonder if it is a bug or an update. Hoping someone has insight into this
Thank you for your response! So Ive used DATETIME_FORMAT In the fields that are being fed and it comes out wrong still. Are you saying somewhere in the larger formula you could drop it in? If so where would it go in this sequence?
IF( FIND("," , {Ti...
