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 Formula Handbook template to find more support resources, and view 100+ formulas, including a glossary of every function that you can practice working with in real time, and examples of commonly used and advanced formulas.

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

Was this article helpful?
YesNo