I believe that I may have asked this in the past but, in the legal profession we use calendar days for calculating dates but, do not want the completion dates for most tasks to fall on a weekend or holiday. Any solution to this? I came up with some fancy formulas to do this but, because Smartsheet uses its calculated date and not my adjusted dates my dates come out incorrect. I still use my formulas to verify the dates and adjust the durations accordingly and hide my working column. Any suggestions?
Thanks,
jerry