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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!