-
IF Formula Counting Multi-Select Drop Down Answers
Hello, I am trying to create a formula using an IF statement that will say "On Track" if there is one answer in the cell, but if there are more than one it will output "Delay". I am assuming my IF statement is counting the answers the way it is working now, however it isn't quite counting correctly and not sure what I'm…
-
Using a dropdown to pull duplicates
Hello, I have created a "helper" column to help me find duplicate entries within a row. So all of my columns are going to be drop down entries so as to avoid spelling or typo issues. If a person appears in "Faculty on PTO" I need to be alerted if they are entered in any other cell for that date. I can easily set up…
-
Rolling 90 Day Formula
Hello, I need to write a formula that will check a box if a date is in the next 90 days, and uncheck if the date has passed. What I have so far is: =IF(Start@row <= TODAY(90), 1,0) So, if the Start date is less than or equal to 'Today' or the next 90 days, then check the box. If the Start date is not in the next 90, then…
-
editing across sheets for text consistency
Hi all, I'm not even sure what to ask for, other than help. I have three key sheets that contain many of the same fields. I've (finally) figured out the Index Match formula to pull matching field in from another sheet (there was much rejoicing!) but now am needing to be able to edit the info. Is there a way to do that…
-
Count Help, Don't Know Where To Start
Hi Everyone, I would like to do a project status summary. Each parent is a school site, and the children are the projects that need completion. In the drop-down menus next to the projects I change the project status to complete when done. I'd like to create a list of all the school sites included in this project that shows…
-
Formula - Adding a Column
Today, I created the following formula in a cell =IF(AND([Roommate in Room?]@row = "Yes", [Requested Bed Type]@row = "Double"), ".5", IF(AND([Roommate in Room?]@row = "No", [Requested Bed Type]@row = "Double"), 1, 0)) As you can see one of the variables returns a .5. The formula works great until I go to my sheet summary…
-
Combine Countifs and OR formulas
I need to get a count of coworkers taking PTO on a specific week. My current sheet counts the week number PTO starts and ends (separate column for each). Is it possible to combine a COUNTIF and OR formulas? A specific example of where I'm stuck is if someone took a long weekend from 4/1/22 to 4/4/22. My sheet will show…
-
Use Formula to Check Checkbox as a Column Formula
I found this formula in the community that works perfectly to check the box if there is any text in certain cells. =IF(OR(ISTEXT([Column1]@row), ISTEXT([Column2]@row), ISTEXT([Column3]@row), ISTEXT([Column4]@row)), 1, 0) I'm getting a column formula syntax error when I try to apply it to the whole column: "The column…
-
Hierarchy issues
Hi everyone, I have been pursuing the forum but I can't seem to find the answer. For some background, my company had a team that set up our Workspace and sheets. One of my coworkers was also the admin but recently left for another job. I have been tasked with taking over admin/owner duties now. I understand the basics and…
-
would like to add an IFERROR to a simple formula, can't seem to get it to work
Hi, I have a simple formula I am using in one of my sheets to calculate a percentage: =[Training/90 day complete]@row / FDS@row I would like to amend it so that if the cell in the Training/90day complete column is blank, to leave it blank rather than calculating it and returning 0%. How would I do that? Thanks in advance!…