adding a decimal to a date does not round up
MarkCep
✭✭✭✭
I have a field that is calculating the average of days, which comes in as a decimal. When I go to add this decimal number to a date to get a future date, it only uses the whole number of the decimal, and if the decimal number is 15.94, it only uses the 15. Why would it not use 16?
Tags:
Answers

have you tried a roundup function? Not sure why it uses the 15.

I could use the round up, but trying to understand why it uses the 15.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.5K Get Help
 62 Global Discussions
 46 Industry Talk
 386 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 466 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!