Create a date based on document type and issue date

I have different document types and their review dates will vary according to type, 1 year or 2 years.

example, if a form or worksheet was issued today then the review date will be in 2 years. If a procedure then the review date will be 1 year from issue.

Col A is document type (currently 3, form, procedure and worksheet, ), Column B is Issued date and col C is revision due on.

Any help would be greatly appreciated.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!