Import from another sheet

Options

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!