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

  • Danielle Arteaga
    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
    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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!