Formula Error



I continue to encounter an incorrect argument error however the formula worked correctly with a previous entry and I cannot determine the cause. See below:

Error encountered with top entry

The formulas are precisely the same with the exception of references and I've checked the formula probably 20 times now and can't seem to identify the problem. I understand there is likely a parenthesis missing but have spent the last hour trying to figure out where.

Any help would be appreciated.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!