-
Project Approval Received / Master Project Sheet Populated
I'm trying to setup an intake process where a new project is submitted through a form and appears within a project intake sheet for review/approval/denial. If approved, I'd like certain, if not all, column values for new projects to be copied over to a master sheet, which includes additional columns for project charter and…
-
Automatically enter category into cell
Sorry, I do not know how to say this. I would like to see if there is a way to automatically enter the category name into a cell. (see image) I've manually put the category in the highlighted box but I'd like to see if there is a faster way? Thank you
-
Cross-Sheet Reference Error
Hello, I am receiving an error window stating that the sheet has reached the max number of different cross-sheet references. Would someone be able to provide more insight on max level of cross-sheet references? Thank you
-
Colour grading
Hi all, Is there any way that i could, based simply on ascending order of numbers, colour code a full column, as i have in the picture below? Thanks.
-
Report not Matching Formula Issue
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 be printed for each workshop: You will see on here that there is: * 3x for the FASTRACK Workshop * 10x for the Van Workshop *…
-
Pull Data from Master sheet to another sheet
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 need a separate sheet so I can use it for widget in my dashboard. I don't want to filter or sort the main master vendor…
-
Every 2 Weeks Alert Not Working
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, it works but the every 2 weeks won't send. What am I doing wrong?
-
HELP - Enabling CAPTCHA on a Form
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: Edit form > Form Options > Checked 'Enable challenge/response for additional security'