Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

=DATE in Stiltsoft defaults to current date

Used the =DATE function in @stiltsoft-expert 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

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.

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

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_ 

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

Atlassian Community Events