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

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!

Comments

  • 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 WilliamsJ. Craig Williams 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.