Same formula returning different results on different sheets

Hello -

I am trying to create a new version of a helper sheet. I have a formula that is working on the old version, but when I copy it verbatim to the new sheet I get a #Invalid Operation error.

Here are the columns on the sheet the formula is working on. As you can see, it's returning accurate values in Days in Pre-Boarding (where this particular formula is located) and in Days in Onboarding. Target affiliation does not come into play for this formula

Here is the error on my new sheet, and a screenshot of the same exact formula that I copied over to the Days in Pre column.

I know I could just use the old version of the sheet and update it, but 1)I put a lot of work into overhauling the new sheet so I'd have to re-create that on the old sheet 2)WHY??? I just can't get over why it's not working.

Any help would be appreciated.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!