IF-Formula together with Index and Match

Options

Hi, I use the Index + Match formula to calculate individual prices with multiple criteria. It works

Now, I want to add an "IF"-formula in order to calculate and show only in these rows where a certain course is requested (f.e. "Angebot Premiumkurs"). Unfortunately I receive "unparseable" - any idea why?

The number 12376 is a price added to the individual calculated factors

Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓
    Options

    Hey @Jörg Schmidt1

    In your IF statement, you need an @row as part of your column name.

    =IF(Marketingname@row="Angebot Premiumkurs";

    Also, unless you wish your ending zero to be treated as a text string, remove the quotes from around the zero. This will allow the character to be treated as a number vs you forcing it to be text.

    Does that work for you?

    Kelly

Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓
    Options

    Hey @Jörg Schmidt1

    In your IF statement, you need an @row as part of your column name.

    =IF(Marketingname@row="Angebot Premiumkurs";

    Also, unless you wish your ending zero to be treated as a text string, remove the quotes from around the zero. This will allow the character to be treated as a number vs you forcing it to be text.

    Does that work for you?

    Kelly

  • Jörg Schmidt1
    Jörg Schmidt1 ✭✭✭✭
    Options

    Hi Kelly, thank you so much for helping. I love to see it working :-)

    Have a nice weekend

    kind regards Joerg 😁

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!