What's the best practice for changing/hiding the default minimum date "12/31/1969 16:00:00?"

[Ryan_Wagner]

I have a “due” column that is calculated after a certain action takes place (effectively a “return date.”) Right now, the default that shows on the sheet and in the app is “12/31/1969 16:00:00.”

What is the best way to have that line be blank in the various views, or is there yet a better idea to illustrate that it is due “now” that I haven’t thought of?

Thanks!

[Marc_Dillon]

You should be able to just leave the column blank. Is there some Initial Value set for that column?

[Ryan_Wagner]

I have a formula computing the value, so I suppose the “default” output if there is no “Last Action” or “Residual” (per my columns) is 12/31/1969?

If I add “” in the initial value, will it create an issue with my formula?

[Marc_Dillon · Accepted solution]

Oh I see. Use an IFS() expression in your App Formula. Something like:

IFS(
  ISNOTBLANK( [Residual] ) ,
  [Last Action] + [Residual]
)

This will return a blank value when you don’t need the calculation.
Nevermind about the initial value.

[Ryan_Wagner]

Thanks, Marc!