Help fixing a syntax error

Options

I am getting a syntax error with the following formula:

=IF([Finish Date] @row > TODAY(), NETWORKDAYS(TODAY(), [Finish Date] @row), -1 * NETWORKDAYS([Finish Date] @row, TODAY()))

I am trying to get a rolling count of net days to the target finish date. Basically count down the number of days left to the finish date and also count the days past the target date (shown as a negative #). Any ideas?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!