Can I use a formula to copy the date from my "Target Date" column to my "Projected Date" column?

mblubaugh

I'm working on creating a project status dashboard to share with stakeholders at my company so they can easily understand where each project stands.

I have a "Target Completion Date" column and a "Projected Completion Date" column. I'd like to be able to use a formula so that when the "Status" column says "In Progress, On Track" it would automatically copy the date from the "Target Completion Date" column to the "Projected Completion Date" column since if a project is on track the projected completion date would not differ from the target completion date.

Is there a way to do this in Smartsheet?

TIA!

JamesB

@mblubaugh

You will want to use an IF statement to get the desired result. I am assuming that if the status is other than In Progress, On Track you will want the Projected date to be blank.

=IF(Status@row = "In Progress, On Track",[Target Completion Date]@row,"")