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.
thinkspi.com
0