Error Message HELP
What am I doing wrong, my formula was working then I tried to add the (@cell) function and now I get the error message
Answers
-
There is no IFS function. Your formula should not have been working even before adding the @cell references.
What error message are you getting exactly?
-
I removed the "S" from the IFS and I get the #INCORRECT ARGUMENT SET message
-
My apologies. I didn't mean that was the only issue with the formula. I was just confused as to how you had it working before the @cell references were added since it should not have been.
What exactly are you wanting to accomplish with your formula?
-
Sorry I added the "S" when I tried adding the (@cell)s
-
Ah. Ok. What exactly are you wanting to accomplish with your formula?
-
I need to define a specific job number to the formula from the 2 sheets referenced later in the formula
-
Can you provide more detail and screenshots of what you are working with as well as some manually entered data to show your end goal?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!