=TEXTJOIN(",",TRUE,IF($D$2:$I$87=M2,$A$2:$A$87,"")) The information being pulled is Dates, unfortunately it keeps pulling the dates as Numbers , I have tried the Text and “dd/mm/yyyy” but im not sure where to put it into the formula, ive tried a couple of locations , but i just get you have entered too many […]
Blog
23423 posts
My initial thought was: “Ah yes! This is gonna be simple! To not corrupt my folders and their contents up (Which I feel like that would happen if I used fsutil.exe on a folder with stuff inside.), I will take everything out, and then run — fsutil.exe file setCaseSensitiveInfo “C:My […]
I have a good working bash script under Linux for creating PFX certificates. But the PKI is a Windows-server, so I always have to copy between Linux and Windows machine. I’d like to do all tasks in one script on the Windows-server with openssl. This basically works, but the created […]
Hi does anyone know how Magento advanced reporting works out the revenue on the advanced analytics reports? their results is very different to what I have. I have tried to calculate net and gross revenue via the data which comes from report > sales> orders and show actual values. when […]
i have written one aja in jQuery , which is folowing settings = $.extend({ method: 'GET', url: decodedUrl, dataType: 'json', cache: false, contentType: 'application/json', data: { aln: '✓' }, showLoader: true, pushState: pushState }, settings); //onDone = onDone || this.onDone; $.ajax(settings).done(function (response) { console.log('response : ', response); }).fail(function (jqXHR, textStatus, […]
I would like to know if there is way to get the originating address details of a Sales Order in Magento (Adobe Commerce). The order API response does not seem to have that detail but it has billing address and shipping address.
I am trying to add the MassAction in listing of Credit Events but get an error as “This tab contains invalid data. Please resolve this before saving.“ This error comes when I am trying to create a New Company but when I edit the company this error doesn’t come. Screenshot […]
I don’t want to remove Nilesoft Shell as I find it very useful, but I need to be able to open files with Notepad++ from the context menu. Has anyone encountered this specific conflict between Nilesoft Shell and Notepad++, and found a solution?
I received a notice from Verizon stating that my Actiontec router needed to be replaced. It said that my old router would still run OK past its obsolescence date, but that if I chose to keep it, they would no longer provide support for it. I agree that I should […]