How to reference the creation date in a formula?

Platform discussions
1

I found {Creation Log#DateTime} describe in issue 41754, but when saving the formula it show the error “A column named “Creation Log#DateTime” doesn’t exist in this board.”

Since this value is not part of the spreadsheet I expect to reference it, but I can’t find it.

The goal is to get the number of months since an item was created. Can anyone tell me the syntax to use?

2

Hi Rob,

Did you add a column of type “Creation Log” to your board?

What if we could break free of the Formula column and write formulas that update any type of columns? What if a formula could update multiple columns at once? This is possible with the Advanced Formula Booster app.

3

Yes, there are two columns: one with the person that created the issue, and one with the date it was created.

4

If you simply insert the column, without #DateTime, does it allow you to save the formula?
So that you know, it works on my boards (both with and without #DateTime, although I don’t see any difference as far as the result I get with #DateTime).

Looking for a simpler way to write complex formulas? Check out the Advanced Formula Booster at https://mdboosters.com. It’s a convenient third-party app that simplifies formula writing. With it, you can spread your formulas across several lines, utilize variables, and access dozens of functions not found in the standard formula column.*

5

The error was cause by something else in the formula, calling rounddown() without the second parameter:

ROUNDDOWN(DAYS(TODAY(), {Created}) / 30)

Adding a second parameter fixed it. Referencing the column name like {name} works.