Smartsheets doing weird things


I posted the below in questions and it got marked as answered before it was actually resolved. I did not mark it as answered. The question I have is also something weird as a formula is calculating incorrectly. See screenshot of the previous question/responses


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!