IFs formula help

holli.nunn

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?

Carson Penticuff

Try this

=IF([Survey Scope]@row = 1, [Survey Completed]@row, [Schematic Prep]@row)

Carson Penticuff

Try this

=IF([Survey Scope]@row = 1, [Survey Completed]@row, [Schematic Prep]@row)

holli.nunn

Thank you, Carson! That worked perfectly!