Date/Time Pulled From 2nd SS

Options
HardWork
HardWork ✭✭
edited 06/16/22 in Formulas and Functions

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)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!