Data Uploader - status won't change if someone has made a manual change previously
I have a tracking sheet of client account numbers. We have one Status column that has options such as "Faxed" "Complete, waiting for download", " Complete", etc.
I have my formula set up so that the status column will change, and it works ONLY if no one has made a manual change to the status previously.
To clarify - we log something on the tracker and manually update the status to Faxed. Then a few days later I upload a file that lists all complete items. This item is on that list and so what should happen is the status will be updated to "Complete, waiting for download" or " Complete" (depending if a value is also present). Because someone has changed that field manually to Faxed, the status will not change. If someone would not have changed the status in the field at all then it updates appropriately.
I think I just need some part of my formula that says "no matter what the status is, update it to this"
Here's the formula just in case - =IF(AND(ISBLANK([Account Balance]@row), [DL?]@row = 1), "Complete, Waiting for Download", IF([DL?]@row = 1, "Complete", "Not Complete"))
Help Article Resources
Check out the Formula Handbook template!