Import from another sheet


Hi, I have all my pay period with start and end date in a sheet (see below). In another sheet, I have a column with period number and I would like to add a formula who would say : If Period in the row 7 is equal to period 2 (or any other period) in my pay period sheet, import the end date of this period.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!