Rounddown

Gaurav Chauhan

Hi, Lets say I have a Program end date of Jul 18th 2022

Months :: =INT([Contract End]@row - TODAY()) / 31

Days :: =([Days to Contract Renewal]@row - INT([Days to Contract Renewal]@row / 365) * 365 - INT(([Days to Contract Renewal]@row - INT([Days to Contract Renewal]@row / 365) * 365) / 30) * 30)

The Months is being calculated as 1 since I am using the available function of Smartsheet to round up/down when under or over .5

I want to use ROUND DOWN option here. How do I write the Bolded highlighted string for rounddown so the result is "0"

Genevieve P.

Hi @Gaurav Chauhan

To clarify, are you always looking to round down if the number contains a decimal?

For example, if the output is 0.98, would that be 1 or 0?

If that would be 0, then you can use the ROUNDOWN function like so:

 =ROUNDDOWN(INT([Contract End]@row - TODAY()) / 31, 0)

Cheers,

Genevieve