Looking to set a Date Field based on contents of another field.

We have a sheet with a list field identifying the target fiscal year and quarter that we want an activity to start eg. FY 23 Q1, FY 23 Q2 etc.

This sheet also has been set up to work as a Gantt view with Start, Finish, and Duration as well.

I'd like to set the start date automatically based on the contents of the FY/Q field. I.E> When the contents of the FY/Q field are set to FY 23 Q1, the Start field is set to 10/1/2022 (October start of FY).

Is this possible? If so how so?

Thanks in advance,

Hudson

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!