If Sheet1A1="X", print "X" to Sheet2A1, from Sheet1, avoid scripts?
Tried to make my problem fit in the title, but will offer more detail:
1) Attempting to do this from mobile as much as possible, so avoiding script usage unless absolutely necessary.
2) Roster management and select system.
Weekly roster and data on new sheets for each week.
3) Already using query to easily print the people selected from overall weekly roster to first sheet.
4) Wanting to use first sheet as a "Current event" tab, so that I/others can easily mark a specific cell in that sheet. Then that cells data would be marked back on the weekly roster sheet for said person.
4.A) Yes this means I am manually updating the query to pull from correct weekly roster...weekly. Easy.
4.B) Passing the info back requires either:
4.B.1) Individual queries on Sheet2 per person. Cumbersom, but mobile friendly.
4.B.2) Script. Easier, once weekly update, but requires PC.
Is there another method to achieve this? Am I missing something in my logic or understanding? I've never attempted force writing to Sheet2 from Sheet1 FROM Sheet1 before. Would love to learn something new!
[link] [comments]
Want to read more?
Check out the full article on the original site