New Contributor

Hi all,

We've created a list template based on the Microsoft template Issue Tracker with some customization made to it and added it as a organization template for our tenant.


There are two columns that seems to be related to the issue.


We have a column that sets a value of the date when an item is created n the list, Date reported, and another column, Days old, that calculates the difference between the date the item was created and the current date. 


Formula for the Days old column in the template is as below:

=IF(LEN([Date reported])=0,0,DATEDIF([Date reported], TODAY(),"d"))


When a list is created from the template the value of Days old column shows a static value of 512. When checking the formula for the column it for some reason changes to the below:


Not sure why it defaults to #NAME? since the Date reported column does exist when creating the list. Is this normal behaviour? If not how would I circumvent this?

Solution we've found for now is just to change the formula back to correct one but we would prefer to not have to do this every time a list is created based on the template. The idea was to have an out of the box use situation.

Screenshots as a reference:

Thanks in advance for your help!