Issues with syntax in my formula- help!

Hey brains trust. I'm having issues getting my column formula to 'stick'. Can you see what I'm doing wrong?

My sheet lets me have this as a cell formula and happily works when I manually copy it into cells below but it gives me an error message when I try to set it as the offical Column Formula

any ideas?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!