In an app I’m making, one date type column [Date A] has an expression to run in the Autocompute section based on another date type column [Date B]. The expression works fine, but if that [Date B] column is left without being filled by the app user, I would like that [Date A] column (which only gets filled based on the date in the [Date B] column) to remain blank too.
But unfortunately, it seems that it doesn’t work if an expression has been written on to the Autocompute section. I tried placing an “IF” expression as in IF(ISNOTBLANK([Date B]),,” ”) but it still brings an error stating that the [Date A] has an invalid value, which I do understand because leaving a date type column blank by this “ “ ought not work actually. I was just wondering if there’s any other way to keep the [Date A] column blank if [Date B] is left blank by the user.