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

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!

Answers

  • JamesB
    JamesB ✭✭✭✭✭✭
    edited 08/17/23

    @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,"")

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!