Attempting to add to a large formula but getting #unparseable

Attempting to add a fifth sheet reference mimicking the previous ones in the formula however getting UNPARSEABLE. I attached a photo of the formula and the updated one below (if i paste it breaks my post) and when in the sheet i notice that the () around cell are orange on the original and green on the new ones so maybe i broke it somewhere along the

way?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!