Return a cell value based on multiple variables

waygjlon ✭✭
edited 12/09/19 in Formulas and Functions

I am having trouble working out a formula to put into a cell. I want the cell to change, based on the value in a cell. 

If the 'status' cell in my document is marked as 'complete', I want to change a cell at the end of the document to 'Complete'. If the status cell is marked with anything else other than 'Complete', I want the cell at the end of the document to return the data that is currently in the 'Owner' cell on my document.  

How do I do this?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!