Match Cell Formula

Options

IF({Project Name} = [Profit Center]@row, {Division}


I am trying to say if the two project names match, populate the division cell.

Answers

  • Valdeir Faria F.
    Options

    Hi Taylor,

    The way I understand your formula is that if the Project Name is the same as the Profit Center in the row, then the Division cell is populated.

    First, are you typing this formula into the Division cell? If so, where you typed {Division} is actually the 'value item' if your logical expression is true. Therefore, your formula should look like this:

    =IF([Project Name]@row = [Profit Center]@row, "value_if_true")

    You would place the word or boolean you want "value_if_true" to populate in the Division cell.


    Let me know if that helps!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!