I can't believe this isn't asked more often...any way of using a Form to populate data into a new column, rather than a new row?
Apologies if this has been addressed previously.
Hi Chad,
Unfortunately, it's not possible as far as I know to use forms for anything else than rows.
What is your use case? How would you like to use it?
I hope this helps you!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Thanks for reply! ...I want to use it for a few things...
1. Column A would be fixed info (material that is typically used on jobs)
2. Form would be used to simply add quantities to new columns, per project, that correspond to Column A titles.
there are several other examples, but, each could be copied from this format (forms that fill in columns).
I realize I could do this in a row, but, I’d rather do it in columns.
Happy to help!
Can you share something so that I can see it visually and maybe get some ideas on how to set it up?
Andrée
Hello community, I need help figuring out how to set up a sheet to collect monthly comments on several projects. Each project is assigned to a different person who need to provide monthly feedback on its progress. Ideally, I would like them to receive a reminder notification on the report due date, followed by reminders if…
Is it possible that a workflow that MOVES rows to another sheet too basically do a CUT/PASTE (like in Excel), and then you are left with BLANK rows on your original sheet? I cannot think of any other LOGICAL reason why this would happen. The users enter the data from an Intake Form, it gets placed onto this sheet. They do…
Hi. I have a sheet where I am sorting dates by ascending order. But the sorting functionality doesn't seem to be working. Instead of bringing all items with date values to the top of the sheeting and sorting them in ascending order, it leaves a gap. Is it a result of the "Next Review Due" column containing a column formula…
