Hi,
I have a worksheet which has approximately 60 entries added to it each day. The worksheet is summarized into pivot tables on another worksheet with a timeline to sort them by dates. I can get this working no problem however with multiple people adding data to the main worksheet my pivot table/ timelines regularly break and require me to delete them and start again. the issue I am having is with my dates. I have a formula in column A so dates are added automatically when a value> 1 is inputted into the adjacent cell in column B. =if(B>1,today(),"") this formula works fine and shows the date the data was inputed in the format i am after. it also works fine in my pivot tables, however when I try to add a timeline to filter my pivot table for a day or date range I get an error saying 'we can't create a timeline for this report because it doesn't have a field formatted as date'. if the time is inputted manually it seems to work fine. is there anyway i can make excel recognize my above formula to recognize it as date format for my pivot tables?
Thanks.
I have a worksheet which has approximately 60 entries added to it each day. The worksheet is summarized into pivot tables on another worksheet with a timeline to sort them by dates. I can get this working no problem however with multiple people adding data to the main worksheet my pivot table/ timelines regularly break and require me to delete them and start again. the issue I am having is with my dates. I have a formula in column A so dates are added automatically when a value> 1 is inputted into the adjacent cell in column B. =if(B>1,today(),"") this formula works fine and shows the date the data was inputed in the format i am after. it also works fine in my pivot tables, however when I try to add a timeline to filter my pivot table for a day or date range I get an error saying 'we can't create a timeline for this report because it doesn't have a field formatted as date'. if the time is inputted manually it seems to work fine. is there anyway i can make excel recognize my above formula to recognize it as date format for my pivot tables?
Thanks.
