Auto Populate from Forms
I have created a form to gather data, from there i the sheet i've created an automation out of it to show in my dashboard. My problem is, i could not find a way that a certain column with formula updates automatically without dragging it?
Here is my formula:
=IF(AND(ISTEXT([Row ID]2), ISBLANK([Logistics Personnel - Assigned]2)), "Open", IF([Case Status]2 = "In-Progress", "In - Progress", IF([Case Status]2 = "Under 3PL / Carrier Investigation", "Under 3PL / Carrier Investigation", IF([Case Status]2 = "Awaiting for Payment", "Awaiting for Payment"))))
i want to have the autofill formula updated once a "case status" has been triggered.
Help Article Resources
Check out the Formula Handbook template!