-
Display column name in a cell if checkbox is checked
I am tracking the status of multiple deliverables (rows 2-7) using checkboxes in multiple columns (8 in total) with the column name describing what status level the deliverable is currently in. I want a reference cell per row that displays the column name of the column who’s checkbox is currently checked. I have the…
-
Calendar App Toolbar and Adding Recurring Meetings to the Calendar
Looking at some video's on using the Calendar App in some there shows a Calendar App toolbar on the left side of the screen, how can I get that added to mine? Also is there a way to setup meeting using the Calendar App with meetings that reoccur? i.e. Every other week, weekly on the same day etc. I'm looking to try and…
-
Which Formula To Use to Return a Value from Another Sheet with Multiple Criteria
I have a sheet in which I'm trying to create a formula to return a value from another sheet, based on an input in another column. I have successfully used VLOOKUP to accomplish this using one criteria, however, there are multiple criteria options. Meaning, depending on the name input into the "Card Holder Name" column, I…
-
Creating forms with common and uncommon columns
I have around 10 forms to create, call them PC01, PC02, PC03, etc. All of the content bones I need for the forms are in a single sheet. There's a column that identifies to which form each question belongs, it's a multi-select column and includes the option of "All" (questions that are common to all forms). I then have…
-
IF(AND Equation - Comma Interrupts Greater Than Logic
Hello - I have an IF AND equation that is based on a "Tier" and "Max Amount." For example, if someone is "Tier 1", their max amount is "$100"; If they are "Tier 2", their max amount is "$200", etc. My equation works properly, except when I reach the thousands. For the equation below, if someone is Tier 4 and enters any…
-
Calculate capacity of the resources based on Project Type, Current Project Duration
Hi, Sheet 1 - Contains following columns Resource Name Project Type Project Duration (Week Number) Sheet 2 - Contains the following columns Project Type Project Duration (Week Number) % Allocation % allocation is different for different combinations of Project Type and Project Duration (Week Number) Ex. For Project Type A…
-
Is there a way to create alerts for non-specific changes?
I'm trying to create an automation that will send an alert when a certain value changes by more than 7. I don't just want an alert for any change, it has to be if the value changes by more than 7. Because of the nature of this specific value, it isn't really possible to have a helper column, at least not that I can tell.…
-
Uncheck Box
I have a formula that says IF(Date@row<TODAY(-14),1,0), to add a checkmark, but how do I add a formula that says once a next recurring date has been added to remove this checkmark.
-
Count IF w/ Multiple Criteria
What should be so simple is turning into a nightmare... I have a "Source" Sheet. In that Source Sheet, I have multiple columns. (example below). What I want is a COUNT of how many rows have "Fred" in the Name column AND "Answered" in the Result column. - so looking at my screenshot, my result here would be 2. I have tried…
-
INDEX/MATCH for Multiple Criteria to create single row
Hi all, and thanks in advance for helping, it is greatly appreciated. This was a solved problem, until it was determined that each Release and the stages needed to be on 1 line, rather than 1 for the releases and then the 7 phases below. The first sheet in my data file which I am linking from. This sheet is owned by…
