Hello, I'm trying to write an IF statement, but I can't seem to figure it out.

Josh J.

Here's what I'm trying to do:

I have a column (Truck Fee) that needs to equal another column (Total Labor) IF column Labor Type = On-Site.

I've read multiple posts that are similar to my situation and some that aren't and still can't seem to get it right.

I've been using (formula being put in "truck fee" column): =IF([Labor Type@row="ON-SITE" then [Total Labor@row])

What am I missing? Any help would be appreciated.

Thank you,

Josh

Find more posts tagged with

Accepted answers

All comments

Leibel S

@Josh J.

Below would be the proper syntax:

=IF([Labor Type]@row="ON-SITE",[Total Labor]@row,"")

Josh J.

Hello @Leibel Shuchat. Thank you for the response. I tried entering this formula. It's no longer giving me an error message, but it's not populating anything in the Truck Fee column.

I have another formula in the Total Labor column already, would that create any problems with this formula?

Do you have any other ideas?

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.