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
-
Could you provide a screenshot of some "mocked up" sample data to show what you are trying to accomplish?
-
Sorry for the delay, Paul. Here are the screenshots in order titled by letters, i.e. "A)"
A)
B) (The form "Person S" would fill out)
C) (Sheet updated with the form data)
D) (Sheet with 7 entries from "Person S")
Help Article Resources
Categories
Check out the Formula Handbook template!