Correct Formula to use

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 ✓

    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:[email protected] | 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 ✭✭✭✭✭✭

    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 ✓

    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:[email protected] | P: +46 (0) - 72 - 510 99 35

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

  • =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å ✭✭✭✭✭✭

    @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:[email protected] | 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!