Help with a potentially complicated formula.

Looking for a formula to do the following with these two sheets. Thank you

Best Answer

  • Monique Odom-Stearn
    Monique Odom-Stearn ✭✭✭✭✭✭
    Answer ✓

    Hello @Delilah!

    I think something like this would work:

    =IF(INDEX(COLLECT({Grant Fund},{Procurement ID},[Procurement ID]@row),1)="EDA SMART MEMS and ODHE Super Rapids",[Total Cost]@row/2)

    The Index Collect part of this formula is collecting the information in the Grant Fund column from the row that matches the Procurement ID. The IF formula is asking: "If the information pulled = "text", then divide the information in the Total Cost column by 2.

    If my comment helped you, please help others by marking it as an accepted answer and consider helping me by clicking the 💡Insightful or ❤️Awesome buttons below!

    Monique Odom-Stearn

    Business Process Excellence Manager

    Smartsheet Leader & Community Champion

    Pronouns: She/Her (What’s this?)

    “Take chances, make mistakes, get messy!” – Ms. Frizzle

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!