Adding different time periods to date
I'm looking for a function to add different time periods listed in one column (either an amount of week, day, month, or year) to a date in one column and output as a final date in another column.
For example first column says 1 day, second column says 6/1/22, and output of function in third column says 6/2/22. See attached picture for desired outcome. I did it in excel and not sure how to translate it to smartsheets.
Help Article Resources
Check out the Formula Handbook template!