Automatically populating a cell from information of another cell

Hello Smartsheet Community,

I am stuck on a specific formula. I want to automatically populate a cell whenever there is information placed in a particular column. At the same time, there is also a checkbox column. I want the information to populate in the cell only if the checkbox row column is checked as well. So for this formula, there are two conditions:

  1. Populate the cell with the information in a specific column
  2. Only populate the cell if the check for the specific column's row is checked

Please let me know if this is a possibility. Thank you and have a great day!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!