Hi, I have created a report to use on a dashboard for showing the number of job cards to print for our workshop. The report is shown below, and you can see that there are different amount of jobs to b…
Hello, I have a master vendor list sheet that contains a checkbox column for vendor type. I would like to create a new sheet that pulls over just the vendors that have the vendor type column checked. …
I set up an alert that says send an alert every 2 weeks starting on Monday, Nov 4 @ 9 a.m., the condition is the status must be 'Open." However, it doesn't send. If I sent it to weekly, hourly, daily,…
I have a business critical form that's getting spoofed (500+ entries in ~3hrs) and am trying to enable CAPTCHA but I can't seem to get it on the form. Here's what I've done using Edge and Firefox: Edi…
I need to transfer rows from one sheet to another that contain formulas. I know that the simple copy and move options just transfer over the values of the cells, but I'm really hoping that someone has…
Hi All, I really need to export my reports and dashboards and the PDF option is too limited. After exporting to PDF and then using a program to convert to PowerPoint or Word, the quality is not the sa…
Hi, I am trying to use the following formula: =IF[Due Date] <=7, "Red", IF[Due Date] > 7 and <=14, "Yellow") IF [Due Date] > 14 and < 30, "Green") How do I do that, I tried to create a new column to s…
I am trying to create an Index / Match cross-sheet formula if two cross-sheet criteria are met. Sheet One displays the Sales Reps for New and Modified Items: I want to display the Item Rep for NEW ite…
