Sheet here: (can’t post due to new user) Column 1 is “Date” type with the time field disabled. Column 2 is “Formula” type: IF({Due Date} != "", {Due Date}, TODAY()) On row 2, if {Due Date} is empty, it automatically fills today’s date, ie, November 5...

I have a date field by name Due Date. Another field by name Formula is a simple formula as follows:- IF({Due Date} != "", {Due Date}, SET_TIMEZONE(TODAY(), 'America/Los_Angeles')) Hence, if Due Date is empty, it simply sets the current date. If Due D...

Hey guys, I have a quick question, looks like a straight forward one. I have a simple {Due Date} field which is of type Date. I’ve created a new field {Due Date?} which simply calculates to {Due Date} if the {Due Date}'s value is present, else calcul...