If Statement - True value results in calculation

JasonB_0718

All,

Forgive the (likely) rudimentary question but I'm relatively new to smartsheet and haven't dabbled in formulas and functions for quite some time.

I'm building a schedule for the ultimate purpose of constructing project dashboards and would like to calculate the number of days behind any given task is. There's the stock start and end dates, predecessors, % complete, etc. I've added a column that has the schedule status as well as the task completion date.

I would like to add "Days Behind" column that essentially functions to calculate the number of days between the completion date and the end date IF the completion date is greater than the end date.

Are you able to utilize NETDAYS as a result to an IF statement?

Thanks for you help!

JasonB_0718

Apologies for the quick post.

I was missing one bracket that my eyes kept glazing over.

If anyone is having a similar challenge, the following accomplished what I was looking for.

=IF(([Completion Date]@row > [End Date]@row), netdays([Completion Date]@row, [End Date]@row))