NETDAYS with nested IF

Options

I am trying to create a formula that counts number of days since an incident and separate it by a particular department. The date would reference a date specified by user when submitting a form. User also identifies department incident occurs in and I want specific counts for each department.

I am currently working with the following formula,

=IF({Region}, "Warehouse", NETDAYS(MAX({Sheet - Data Input Tracker with Form Range 5}), TODAY()))

Currently getting a return of "Invalid Data" if I change the IF operator to = I get Invalid operation.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!