How can I add days to dates based on text in another column?
I need to have a specific number of days added to a date that is in Column A, and have it add days to Column C, based on the text that is in Column B. Example:
Column A is SC (needs +20)
Column B is 7/29/2020
Column C should = 8/18/2020
I have found that (A1,"SC",B1)+20 works per text, but I have 12 different variances of this formula, all with different days that would need to be added based on specific text in Column A. Any help would be greatly appreciated, I just cannot get the formula to be specific based on the text.
Answers

You COULD use a nested IF formula to account for every difference in Column A, but updates/additions/removals would be very cumbersome.
I would suggest creating a table that has each of the Column A variables listed out in one column and the corresponding number of days listed in another column.
Then you could use something along the lines of...
=[Column B]@row + INDEX([Table Number Column]:[Table Number Column], MATCH([Column A]@row, [Table Variable Column]:[Table Variable Column], 0))
This will look for the value in Column A within the table and pull the appropriate number to be added to the date.
Working with a table like this means that any time you need to add, remove, or change a variable or number of days, you only need to update the table which (in my opinion) is much easier to manage than trying to manage a long formula and then updating all instances of said formula on the sheet.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.4K Get Help
 364 Global Discussions
 200 Industry Talk
 430 Announcements
 4.4K Ideas & Feature Requests
 137 Brandfolder
 129 Just for fun
 128 Community Job Board
 446 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!