FLOOR Function

Rounds a number toward zero to the nearest specified multiple of significance
Sample Usage
FLOOR([Price Per Unit]1, 2)
  • number
  • [
  • number
    The number to round down
  • multiple
    The nearest multiple of significance in which to round

Still need help? 

Use the Smartsheet Formula Template to view examples and practice working with functions in real-time. 

Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.

Ask the Community