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.
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.
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.