LOG Function

Cory Griffis

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?

Paul Newcome

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.

Debbie Sawyer

@Paul Newcome Did you ever come across a solution for simulating a Log function in Smartsheet?

Paul Newcome

@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.

Debbie Sawyer

@Paul Newcome

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

Paul Newcome

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.