-
Add Not Blank to formula and display word
I need to add another element to the following formula. The below formula works beautifully, however now I need to look at another column to see if there is a date displayed and if so (not blank) then display the word "Termed". Current formula: =IF(AND([Trailing 24M ratio]@row < 1, [Trailing 12M ratio]@row >= 0.9), "Yellow…
-
How can you delete the yellow RYG status dot from the drop-down list?
My team is working on a status sheet and is using the drop-down RYG gumballs/dots for status. However, we are only working with Red, Green, and Blue. We would like to remove the yellow dot option so people are not choosing a status option we are not using. Is that possible? has anyone ever been able to do that? Thanks!
-
Using Logic to Autofill Other Fields in a Form
I have a form where a user would select options from a drop down. Ideally, like to setup logic so that when they select option D, there is another form field (let's just call it Field 2) that is then hidden and has its value set. There are other times when if they were to chose Option C, they would need to decide what…
-
Access Hidden Confidential Data
I need to "hide" employee salary data. I would like to have a separate grid spreadsheet with the data in it, I have locked the cells. When I link to the cells from another sheet, the actual amount shows up. How can I hide this from the sheet I link it from. To add more, this is to figure margin based on bill rate of a…
-
Formula to show Health of opportunity based on 2 status columns and due date
I'm trying to write a formula that will change the Health column to B, G, Y, R depending on status of 2 columns and the due date. When the OPP STATUS is Closed/Won, the SETUP STATUS and the START DATE will determine the color indicating the health of the opportunity. I am grateful for all of the help I have received from…
-
Cross referencing Sheet-formulas
Hi I want to look up the requestor name ,Department rep,Department Rep(second if applicable) for each Tracking ID from another sheet which contains the names of these department reps. If a department name is entered the corresponding column should return the name of the rep from the other sheet. Which is the best function…
-
How to List Parents By Common Child
I am working on a project book of work and currently have a list of resources listed by project: Project 1: Rich John Angela Carly Ted Project 2: Tim Jeff Rich Ted Project 3: Sam Tim Ted I am looking to create another sheet that will automatically pull from this first sheet and show the resource and the projects that they…
-
TODAY() Automated workflow birthday not calculating correctly
We've automated a work flow for birthday notifications - so we can celebrate folks. The workflow/notification shows an incorrect calculation - age = 20, when it should be 21. Here's the notification: And here's the data we're pulling from, showing the correct age calculation: I'm assuming this may have something to do with…
-
COUNTIF year is current
Can anyone tell me what is wrong with this formula for counting rows containing the current year? =COUNTIF([Date Completed]:[Date Completed], YEAR(@cell) = YEAR(TODAY()))
-
Less than or equal to 6 months equation
Hello, I have a formula that I can't quite get to work as the DATE options confuse me. In my sheet I have a Trial Building Evacuation date. I want my formula to show 'if the trial building evacuation date occurred less than or equal to 6 months ago, to give a score of 1'. What formula should I use? Thanks Sharyn