Date/Time Pulled From 2nd SS

HardWork

I have two sheets I am working from. Sheet 1 has the START DURATION and Sheet 2 has the END DURATION. How do I point to the 2nd SS to pull in the END DURATION? I have Notification Numbers that are associated with the two and then I am using this formula to provide time only.

=RIGHT([Approver Time Stamp Close]@row + " ", LEN([Approver Time Stamp Close]@row + " ") - 9)

Kelly Moore

Hello @HardWork

To clarify - you already have your Time separated out into a separate column on your second sheet and you only want to bring this time portion over? Assuming yes, the formula below should work.

An INDEX/MATCH will work for you. Because this is a cross sheet reference (the data is on a second sheet) you cannot simply copy paste this formula. You must insert the reference from within the formula wizard window.

=INDEX({Second sheet End Duration Time column}, MATCH([Notification Number]@row, {Second sheet Notification Number column},0))

Does this work for you?

Kelly

If interested, here is more information on the formula used

https://help.smartsheet.com/function/index

https://help.smartsheet.com/function/match

https://www.smartsheet.com/content-center/best-practices/tips-tricks/powerful-and-flexible-cross-sheet-formulas#:~:text=Here's%20how%20to%20reference%20another,that%20info%20into%20a%20sheet.