Correct Formula to use

Arodthom

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.

Andrée Starå

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!

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å

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!

Arodthom

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

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

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!