I need to add a filter where “Date Arrive is on or before 4/30/2020” AND “Date Arrive is not empty” AND “Departure Date is empty” OR “Departure Date is on or after 4/1/2020”
I can’t do filters with AND plus ORs… Can someone tell me another option?
Fo...
I have 10 checkboxes in my table. Each checkbox corresponds with a task that needs to be completed.
I’d like to build a formal that shows an emoji each time another checkbox is checked.
For example, if you’ve checked 4 boxes, there would be :white_c...
Please help!
I’ve got a long term storage business and my base has a table that stores the following:
Customer Name - TextArrival Date - DateDeparture Date - Date - Date they left and therefore STOP getting chargedSetup Revenue - Currency - They get ...
formulas, by definition, automatically calculate therefore you can’t keep values stored in a formula all.
I think if you could show the structure of your airtable, it would help.
Jeremy_Oglesby:
IF({Checkbox Field 1}, “ :white_check_mark: ”) & IF({Checkbox Field 2}, “ :white_check_mark: ”) & IF({Checkbox Field 3}, “ :white_check_mark: ”) &
Great Stuff! Thanks for the help!
This is a tough problem. In a traditional web application we’d separate the data from the reports. I’d use a date range as “inputs” for a given report. It’s hard for me to wrap my head around making everything a new “column” and storing calculated da...
Your nesting is backwards. The second IF is triggering a True statement and therefore the final IF is never processed. You could change it to this:
IF({Risk Score} >= 12, “ :red_circle: ”, IF({Risk Score} < 6, “ :battery: ”,IF({Risk Score} < 12, “ :l...
