Is there a formula to check the box if the cell does not contain a whole number?


I am tracking orders and they need to be in multiples of 360. Is there a formula to figure out if it is a multiple of 360?

I could not figure one out so I have a column dividing the two with the result being either a whole number or not (1 or 1.24). Is there a formula to check a box if the cell is a whole number?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!