Different between Excel and Smartsheet Formuale
Would you be aware of to why Smartsheet would calculate the same data differently. I ran the Pivot for validation and those numbers don't tie back to how Smartsheet picked it. The COUNTIF formulae and all is correct with no errors or anything. Even with status types GH IJ and KL where one can filter out data manually on Smartsheet and look at count, how did Smartsheet calculate wrong
Can you share your experience with such a scenario and suggest for a fix.
Help Article Resources
Check out the Formula Handbook template!