or Explore Discussions

#### Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

# Formula help

edited 12/09/19
09/29/17 Edited 12/09/19

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!

Tags:

• 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

• Top Contributor

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

This discussion has been closed.