Help fixing a syntax error


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!