IFs formula help

I have written a simple formula to pull the date from one column into another on every row of my sheet. ( =[Schematic Prep]@row)....converted to column formula.

Now logically I understand that there are some projects in this sheet that must pull the date from a different column IF the "Survey Scope" Check box is checked.

So, Within the column this formula is for ("Revit Shell Due Date"), I want to write a formula that will pull the date from 'Schematic Prep' date column unless the 'Survey Scope' check box is checked. If it is checked then I would like the date to pull from the 'Survey Completed' date column.

I suspect an Ifs statement may help but I am unsure how to write the formula. Can anyone help me?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!