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.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!