Auto Populate a date if another cell contains specific text

Options

So I am sure this has been asked, but i cant seem to find anything on this topic.

I am looking for a formula that will auto populate a cell with a date if another cell within that same sheet contains specific text.

Example: If [Assignment]@row, HAS "Audit", then place a date in [Audit Due]@row

  • Searching for Specific Text in the Assignment Column that has "Audit"
  • Needing a date placed in the Audit Due Cell
    • If the formula can include this, that would be great (Audit Start + 1)

Julie Becker ☠️

Construction Project Engineer / Coordinator & Software Program Oversight Mgr. 😉

Successful People Are Not Gifted; They Just Work Hard, Then Succeed On Purpose‼️

Tags:

Best Answer

  • Jason Albrecht
    Jason Albrecht ✭✭✭✭✭✭
    edited 08/02/23 Answer ✓
    Options

    Hi @Julie Becker

    Would this work for you?

    =IF(Assignment@row = "Audit", [Audit Start]@row + 1, "")

    If so, you can then convert the formula to a Column Formula by right-clicking in the cell, and choose the relevant option, like so:


    Hope this helps and that you have a great day,

    Jason Albrecht MBA, MBus(AppFin), DipFinMgt

    LinkedIn profile - Open to work

Answers

  • Jason Albrecht
    Jason Albrecht ✭✭✭✭✭✭
    edited 08/02/23 Answer ✓
    Options

    Hi @Julie Becker

    Would this work for you?

    =IF(Assignment@row = "Audit", [Audit Start]@row + 1, "")

    If so, you can then convert the formula to a Column Formula by right-clicking in the cell, and choose the relevant option, like so:


    Hope this helps and that you have a great day,

    Jason Albrecht MBA, MBus(AppFin), DipFinMgt

    LinkedIn profile - Open to work

  • Julie Becker
    Julie Becker ✭✭✭✭✭
    Options

    This is perfect. thank you so very much.. i had a feeling it was a simple formula, but i couldnt wrap my head around it (or i was simply overthinking it all together) and all the searching in the world wasnt giving me quite what i needed.. So again thank you for this solution

    Julie Becker ☠️

    Construction Project Engineer / Coordinator & Software Program Oversight Mgr. 😉

    Successful People Are Not Gifted; They Just Work Hard, Then Succeed On Purpose‼️

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!