Move select column data to new row
I have a Smartsheet form that allows employees to request up to 5 unique dates and times (to come on campus). For these dates and times, I have columns: Date1, Time1, Date2, Time2, etc.
Ideally, I'd like to have one column of date and one column of time so that I can pull a report on a daily basis for our access point security officers.
To accomplish this, I have a workflow that copies any new request/row to a new Sheet. The number of rows created is based on number of dates entered. In the new Sheet, I have two new column-- Access Date and Access Time. However, I am not sure how to move the cell Date2 to second record for the same request, and Date3 to the third record, etc.
I have tried creating unique ID to identify the row and DataMesh, but I am missing the "instruction" to direct Date2 to a specific cell. I think Joint(collect) formula might be helpful, but I am not sure where to start with it.
Any suggestions would be appreciated. Thank you.
Help Article Resources
Check out the Formula Handbook template!