r/googlesheets•
Rozmere

How to Automatically Create Rest of Row

Unsolved

So I have a Google form (order form) that submits data to a Google sheet (a manifest of a sort) when the salesperson clicks submit. This fills in all the data from the form on a new line. But, I also need this sheet to automatically add other things to the newly created row. For example, I need checkboxes in two columns (let's say columns K and L just for this example). I will also need conditions automatically assigned to the created row. One of the conditions is "If the check box in column K is checked the row is colored yellow" Another condition is "If the checkbox in column L is checked the row is colored green". To be clear these checkboxes are not on the form that submits its data to the sheet, these checkboxes are for workers to check after the order has been processed and then when it has been approved. How do I make this happen?

Posted Aug 18, 2024, 7:55 PM UTC

27
Loading comments…