Creating scheduled date from last date given


I am having problems creating a formulla .The formula needs to reflect the due date which is: Date of Last PCR Test + 14 days.

I tried the following but its not working:

=[Last PCR Testing]@row + 14 days()

Any help would be grateful

Best Answer

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Answer ✓

    Hi @Vinton Douglas 

    Hope you are fine, the 2 column must be Date type column then try the following formula and convert it to column format formula:

    =IFERROR([Last PCR Testing]@row + 14, "")

    the following screenshot shows the result:

    PMP Certified

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!