Round Robin/Cue Function?

Hello, I'm looking to incorporate a simple round robin feature, i.e.:

Column Header Titles: C1) Unique ID C2)A C3)B C4)C

Step 1) Person S uses simple form that only requires Person S to enter a unique ID - the person enters that and saves it

Step 2)That information entered would be saved to column C1.

Step 3) That information is then copied to column C2.


Repeat steps 1 and 2.

Step 3) That information is then copied to C3.


Repeat steps 1 and 2.

Step 3) That information is copied to C4


Repeat steps 1 and 2.

Step 3) That information is copied to a new row under C2.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!