Hopefully a pretty easy question that I need help with.....
Hi all,
I am newish to using formulas, and I am stuck. All I really need to do is have one column return as "true" based on the status. I am getting an error message. This will allow me to calculate my data in an Excel pivot table.
=IF(CONTAINS("COLUMN NAME",@row), 1, 0)
What am I missing?
Thank you!
Answers
-
Hi, Devon. We need a little more information to answer your question.
Generally, your formula should look something like this:
=IF(CONTAINS([Column Name]@row), 1, 0)
Column names go in braces [], not quotation marks. Also, you do not need a comma between the column name and the @row specification.
See if this helps. If not, can you share a little more information about what you want the column you're pointing to to contain?
-
ah, that makes sense, thank you Danielle! One additional (very important item I didn't include: it is a check box option. I am seeing some edits based on that directive online and it still isn't working/giving me an error message. Attaching the error, and on the form it is one check box for that request.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!