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

hsandberg18371
edited 12/09/19 in Archived 2017 Posts

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

This discussion has been closed.