Hello, I'm trying to write an IF statement, but I can't seem to figure it out.
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
Answers
-
-
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?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!