LOG Function

Options
✭✭✭✭✭

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?

Tags:

• ✭✭✭✭✭✭
Options

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.

• ✭✭✭✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!