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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.2K Get Help
 360 Global Discussions
 199 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 444 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!