Inconsistent Formula Error
Have you came across this situation?
I am working on a formula to calculate base on month and staff. The same formula only works for some staff and I am wondering what went wrong.
I am using exactly the same formula for both staff. But one is showing #Invalid Data Type (in our formula we use "ERROR" to indicate if there is any error).
It is referencing the same data source. What could be the issue here?
Help Article Resources
Check out the Formula Handbook template!