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?
Help Article Resources
Check out the Formula Handbook template!