=DATE in Stiltsoft defaults to current date

Lisset Salazar September 13, 2022

Used the =DATE function in @[deleted] table spreadsheet. I wanted to use the (+) like in excel to drag the function to the other cells, but the date kept defaulting to today's date. Is there a way to add =DATE without having to manually fix the date in each cell? 

 Screen Shot 2022-09-13 at 2.02.22 PM.png

1 answer

4 votes
Katerina Kovriga {Stiltsoft}
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 14, 2022

Hi @Lisset Salazar,

Thanks for noticing: indeed the behavior of the =DATE() function is not correct. 

We've created a ticket for the developers and attached this question to it, so I'll be able to return here after the fix-release and notify you shortly.

Katerina Kovriga {Stiltsoft}
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 19, 2022

Hi @Lisset Salazar ,

The fix for the =DATE() function has been released today - you may check its behavior.

Please note that the new version of the app may take 1-2 days to reach all the Cloud instances.

Like # people like this
Lisset Salazar September 23, 2022

Will the fix apply to tables that already exist, or will we see it only when creating a new table? Thank you @Katerina Kovriga {Stiltsoft} 

Katerina Kovriga {Stiltsoft}
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 23, 2022

The correct behaviour should be applied to all the spreadsheets containing this function - its encore functionality was improved.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
TAGS
AUG Leaders

Atlassian Community Events