Auto Populate a date if another cell contains specific text

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)

Find more posts tagged with

Formulas

Accepted answers

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:

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.