Formula help

I'm looking to write a formula that looks at cell A1 and if it contains "Sent" within the text of the cell, it grabs the number in cell B1 and writes it in C1.

Example:

Cell A1 = "Sent w Statement"

Cell B1 = $100.00

I need C1 to populate $100.00 because A1 has the word Sent within the text

Any assistance is greatly appreciated. What works in Excel doesn't work on Smartsheet, in this case.

Thank you!

Find more posts tagged with

Finance

Formulas

Services

Comments

SmSulli

Hi!

This should do the trick. Put this formula in C1.

=IF(OR(FIND("Sent", [A1]1) > 0, FIND("sent", [A1]1) > 0), [B1]1, "")

Good Luck

Shawn

J. Craig Williams

I believe he is using row/column notation -- so A is the column name, not A1

=IF(OR(FIND("Sent", A1) > 0, FIND("sent", B1) > 0), B1, "")

should be the correct formula, if my assumption is correct.

Craig