This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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...
Hi @Justin_Barrett,
Thanks for suggesting the GMT option. For now, I had to turn it on for this to be working. The SET_TIMEZONE doesn’t work correctly if the GMT property is not set.
Abhijeet
Hi @JonathanBowen, probably because I’m a new member, I don’t have permissions to post a link here so I can’t share the base here.
I tried your formula too, which is definitely cleaner, it still shows me the older date. If it matters, I changed the t...
