PRORATE Function

Returns a portion of a value divided across a provided date range
Sample Usage
PRORATE(100, [Due Date]1, [Due Date]4, [Due Date]3, [Due Date]4)
Syntax
PRORATE(
  • number
  • start_date
  • end_date
  • prorate_start
  • prorate_end
  • [
    decimal_places
    ]
)
  • number
    The number to prorate
  • start_date
    The first date in the value range
  • end_date
    The last date in the value range
  • prorate_start
    The first date in the range to prorate
  • prorate_end
    The last date in the range to prorate
  • decimal_places
    —[optional]
    The default is 2. The number of decimal places to round the result
Examples

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