Super Simple: need to reference a date from one cell to another


In my project plan, I am using the Start/Finish as my baseline and then Actual Start/Actual Finish as my actuals. I would like to have a formula for my actual start be the baseline start so all I need do is then put in the Actual Finish. I need a formula to copy the date in the Start column into the Actual Start. For the life of me I can't get it to work. In XLS its super simple: =D3 but that same logic doesn't seem to work in Smartsheet.

Best Answer

  • Jon Mark H
    Jon Mark H ✭✭✭✭✭
    Answer ✓

    Hey Pamela!

    The formula should be: =Start@row - this will pull the Date from the Start date row (assuming it's called "Start" & that your "Actual Start" column is also formatted as a Date Column.

    If you don't want it working on each row - you can do a specific reference, like D3 in Excel - this would just be:


    Let me know if this helps or if you have any further questions or issues!

    -Jon Mark


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!