-
Automate harvey balls with completion status
I am trying to automate the RGY Harvey balls in a sheet based on the status of the Full/quarter/half/three quarter/full Harvey balls.Below are the statements that I want to use but I was hoping to get some help putting them together in a nested if statement. if End Date is before today's date and Completed is full then…
-
Formula Tips are Obscuring the Actual Formula
Hello, Could anyone provide a trick to move the formula tip dialogue box? I am getting an Unparseable error message, but I cannot see the formula to check the syntax (see attached screen shot). Are other people facing this problem? Is it browser specific? I am working around this by copying and pasting parts of my formula…
-
Anonymise form submission
Hi, I have a form which fills a sheet with an "Anonymise" checkbox column and a "Submitter" text box column. (staff feedback form) I'm trying to give form submitters the option to anonymise their submissions. At the moment, an individual has their own link which will auto-populate the submitter on the form but want to be…
-
Harvey Balls Automation
I am trying to put together a formula to automatically change the RYG harvey balls based on the end date(due date) and the completion status of the empty/quarter/half/three quater/full harvey balls? I was hoping to get some help putting the nested if statement together. Here are the conditions I am working with and a…
-
Auto Assign w/in Marketing Request Tracker
I am trying to figure out how to write a formula to auto assign a task when it meets different criteria. For example, my column is "Type of Request". If it is Creative, then I want to assign Kristi from my contact list. If it is Product, I want to assign John. I have 7 different choices within the Type of Request column…
-
View Ranges Used in a Sheet (or all sheets)
Hello, I would like to know where I can go to make edits to some of the ranges I created. Normally, I can see the ranges I have created by just clicking on the cell once (rather than double-clicking to edit), but my formula is too long and it pushes the range links off the page. Please see attached screenshots. Any help…
-
Checkbox populate contact list
Hello all, I am hoping someone knows of a formula that could automatically populate a contact list when a checkbox is ticked. It is a sheet that keeps track of inventory and I would like to be able to keep track of who is breaking the minimum quantities without relying on the person to use a drop down box to insert their…
-
countif with dates
Can anyone tell me what might be wrong with this formula? I'm trying to count the number of items that are complete, as noted by the presence of a date in the date completed field. I need to know the number of fields that have a date in 2018. Thanks =COUNTIF([Date Completed]1:[Date Completed]14, "=>1/1/18")
-
Formula Help- Check Box if Date is tomorrow
Hi! I need a formula so that if a date column is the next day, a box is checked. This is what I've started, but I can't figure out how to say- if the date is tomorrow... =IF(date:date=????,(1)) Any ideas? Thanks! Amy
-
Alerts for deadlines- Need help
Hi! I am trying to set up an alert for deadlines, but only if a box is checked- not for the whole sheet. So people can basically choose- yes, I want alerts for my deadlines, or - no, I don't want alerts for my deadlines. Right now I have a check box column set up- yes and no. So, I want it so that If the person checks the…