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

  • Paul Newcome
    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.

    thinkspi.com