I’m trying to build an IFTHEN in the Glide Editor that would perform the same action as this formula:
ARRAYFORMULA(IF(C2:C="","",IF(C2:C>(today()+180),“Too far away”,"")))
The goal is to prevent a booking that is 6 months (180ish days) into the future. It currently works with the ARRAYFORMULA, but there is a delay because the sheet has to perform the calculation.
There aren’t any real date calcs in the editor and I can only use Today or Now as options when building conditions based on dates. Does anyone have an idea for a work-around?