Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Calculating a Due Date
Frequently in legal transactions a transaction closing date may depend on the outcome of a couple or more previouls tasks. It will be the later of two or more previous tasks. Each task's completion date plus a different number of days depending on the task. The answer is the latest plus another specified number of days. The problem is that you cannot place a formula in an End Date. Well, you can if you create a new "Date Column" which becomes your calculated "End Date". You can place your formula in the cell that needs to be calculated based on the previous two End Dates. In the other cells that don't need any additional calculations you can just make them equal to the normal End Date cell in its row (=[Due Date]5 ). The column that contains the normal calculated end date is hidden and the new date column becomes your End Date. Maybe no one needs to do this and maybe I am making it way to complicated. But, I think it is going to be very useful in our situation. If anyone is interested in this let me know and I can enter the formula.