Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Is There Really No Built-in Log\NL Function?
My team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula. Are we missing something; Why is the SS math library so dumbed down?
Below is the formula in Excel we are trying to migrate.
WHERE: A2 is a user input field for the number of user impacted by the issue.
Clearly you could do something with a bunch of nested if statements that would work but it would be a mess.
- Media & Entertainment
- Project Management
- Metals & Mining
- Product Development
- IT & Operations
- Financial Services
- Real Estate
- Energy & Utilities
- Enhancement Request
- Solution Center