Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
DAYS360 Formula
I'm trying to move various spreadsheets from Excel to Smartsheet but I keep needing the DAYS360 formula. It is very common to calculate loans based on 360 day years so monthly figures remain constant (at 30 days/mo). I was very surprised to see that this formula is not supported by Smartsheet. Is there a way to mimic it? Any idea if/when Smartsheet will support this formula?
Comments
-
Hi Jeff,
As you have found, Smartsheet currently doesn't have a function similar to DAYS360. When you have a moment, submit a Product Enhancement Request to let our Product team know that you'd like to have this function in Smartsheet.
For a list of all the date functions available, please see: https://help.smartsheet.com/functions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.3K Get Help
- 463 Global Discussions
- 156 Industry Talk
- 508 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 517 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 307 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- Hi, I would like to do a simple count and countif based of my portfolio report. But when I start the formula and want to link to the report, it is not available for selection. I am the admin/owner of …
- Trying to count if a cell by criteria if another cell contains "device": =COUNTIFS(CONTAINS("Device", [eCOA Department]:[eCOA Department]), [Award Date]:[Award Date], >=DATE(Year#, 3, 1), [Award Date]…
- I have been trying to work on a formula within smartsheet and only part of the formula is working and I have been using AI through smartsheet. I need help with tha last 2 parts of this formula to get …