Auto Populate a date if another cell contains specific text

Julie Becker

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)

Jason Albrecht

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:

Jason Albrecht

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:

Julie Becker

https://community.smartsheet.com/discussion/comment/388379#Comment_388379

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