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?

Find more posts tagged with

Formulas

functionality

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.