Formula Syntax Help - Identifying suffix on number.


I have a sheet tracking orders. Each order has multiple order lines (each item on an order has a separate line with a decimal suffix). I would like to identify each primary order line (order line ending with ".0" but I'm struggling with the formula. I currently have this keyed as a formula =if(Order Line1,right([Line]1,0)"Primary". "") Obviously this is not correct. Can someone help me figure out the correct syntax to return "Primary" in my helper column?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!