Correct Formula to use

Options
Arodthom
Arodthom ✭✭
edited 06/20/22 in Formulas and Functions

Hello, I'm new to Smartsheet. I'm needing to find a formula to say "if this column says active, then pull the numbers from this other column. If it doesn't say active, do nothing or leave blank." All info is on the same sheet.


Thank you for assistance.

Best Answer

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi @Arodthom

    I hope you're well and safe!

    I agree with Kelly, and it would be best with more information.

    Try something like this.

    =IF([Active Column]@row = "Active", [Other Column]@row, "")
    

    Did that work/help?

    I hope that helps!

    Be safe and have a fantastic week!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Options

    Hey @Arodthom

    The community needs a bit more information in order to try to help. In your question above, what criteria will determine if your column is 'active' or 'not active'? Will the column cell change from a blank cell to a populated cell? Or, does the status change from 'Pending' to 'Active'? Also, what kind of column is it? Text/Number? Checkbox? Date, etc? Screenshots of sheets (sensitive data removed) are always helpful.

    Kelly

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi @Arodthom

    I hope you're well and safe!

    I agree with Kelly, and it would be best with more information.

    Try something like this.

    =IF([Active Column]@row = "Active", [Other Column]@row, "")
    

    Did that work/help?

    I hope that helps!

    Be safe and have a fantastic week!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Arodthom
    Options

    =IF([Active Column]@row = "Active", [Other Column]@row, "")

    was a perfect solution! I appreciate your help with this item.

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Options

    @Arodthom

    Excellent!

    Happy to help!

    Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!