LOG Function
Is it possible to calculate (or even approximate) a LOG function in Smartsheet? We regularly use the below formula to calculate A/E fees:
(35/LOG(Construction Cost))-1.15)*(Complexity Factor) = A/E fee %
I have a sheet setup where someone can enter a construction cost, and a lookup table for the complexity factors based on project type, but I then tried to input this formula for the fee %, but I get an #Unparsesable result. Am I doing something wrong, or is there really no way to perform this calculation in Smartsheet?
Answers
-
Smartsheet does not have a LOG function, but I feel like we may be able to come up with something else that mimics the logic. Unfortunately my brain just doesn't want to work anymore today, so I may not be able to come up with something until after the weekend. I'll keep you posted.
-
@Paul Newcome Did you ever come across a solution for simulating a Log function in Smartsheet?
-
@Debbie Sawyer I honestly forgot about this. I have bookmarked the thread, but if I don't respond by the end of tomorrow, feel free to tag me in a reminder on Monday.
-
I was asked yesterday by another consultant if I knew of a way of simulating this function and I didn't, so I searched and found this, so I thought I'd ask. Don't worry too much about it Paul, if it isn't there and can't be done then we just need to tell the client that!
I just thought if you had already solved this particular puzzle then you might be willing to share!!
Kind regards
Debbie
-
Not yet, but I will definitely share if/when I figure something out. Things have been a little crazy lately, so finding time for the more complex solutions here in the Community has become increasingly harder.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 464 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!