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)
Julie Becker ☠️
Construction Project Engineer / Coordinator & Software Program Oversight Mgr. 😉
Successful People Are Not Gifted; They Just Work Hard, Then Succeed On Purpose‼️
Best Answer

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 rightclicking 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

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 rightclicking 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

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
Categories
Check out the Formula Handbook template!