Forum Discussion
Need your help to create a timeline column
Hello this thread is not active because the data in the files I posted were not accurate and caused a lot of trouble please go to the new thread were I corrected the data in this link thank you. htt...
Do you really want to calculate CreatedOn minus today? You get a of lot negative values.
And there is something wrong with your dates. Some of them are in the future.
Hello Detlef, regarding the " CreatedOn minus today" yes my mistake i switched them around i meant " Today - Created On "
and regarding the future dates some of them is " Estimated Close date > Est Close Date " it's just a estimate on when the deal will be closed, and regarding the closed deals that are in the future yes indeed your right but this is just an example on how the data is structured if you are saying that the formula wont work because of this i will update the dataset now thank you
and regarding the future dates some of them is " Estimated Close date > Est Close Date " it's just a estimate on when the deal will be closed, and regarding the closed deals that are in the future yes indeed your right but this is just an example on how the data is structured if you are saying that the formula wont work because of this i will update the dataset now thank you
Then it is simply:
=MAX([@[Close Date]],TODAY())-[@[Created on]]Future dates will have negative values.