Hopefully a pretty easy question that I need help with.....

Devon

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!

Danielle Arteaga

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?

Devon

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.