I'm having trouble understanding how to use the Gantt settings on my structure. I want to be able to visualize a "projected finish date" based on today's date + the remaining estimated time. The formula I'm using is
DATE_ADD( today(), CEILING(JIRA_DAYS(remainingEstimate)), "day")
which is working in terms of rounded up, raw days. However I want the Gantt chart to take that information and use my Work Calendar setting to take into account weekends and holidays to actually spit out a date.
Am I overthinking this? Is there a setting that will already do this?
Thanks in advance!
Yvette
