Creating a formula based on data

Hey community!

I'm trying to create a formula in a column that will pick up a value if a box contains certain text.

i.e. IF 'Won' is selected, the cell is to copy a value from one cell and place it in another.

Is someone able to assist? If you need more info, please let me know :)

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!