-
Error when using multiple SUMIFS in one column
Hi . I am trying to find the sum of each group of 5 rows using SUMIFS in Column 1 where the employee's name is John Smith (in cell 3 in Employee Name's column) and the status is Full-Time (in the Status column). =SUMIFS([Column1]:[Column 1], Employee Name: Employee Name, Employee Name3, Status:Status, "Full Time") The…
-
Joining multiple select columns into one column
Hi, I have 2 columns that are multi-select and one column that a text column. I am looking for a formula to be able to get them all in one multi-select column. I want multi-select column Missing 1 and multi-select column Missing 2 and text column ID problems to all combine in the multi-select column Missing. I used the…
-
IF formula for a cell that is not colored and blank
Is there a IF formula where I can check off a box if all the cells in a row that are not colored are filled?
-
Count if project is starting within the next 30 days
Hi, I'm trying to count how many projects will be starting within the next 30 days. I understand I can filter, but i need to run a report and I'm having difficulty with my formula. I'm fairly new with formulas. I continue to receive a "unparseable" error" . Any help would be greatly appreciated. Thank you in advance.…
-
Is there a way to not type DATE formula manually?
I have a sheet with the date as the column name and have a cross-sheet formula with SUMIFS and DATE. Is there a way I don't have to type the date manually? Unfortunately, I have over 100 columns that I need to modify the date to match the column 😥 You'll be a lifesaver if there is a way! Thank you in advance!!🙇♀️
-
#DIVIDE BY ZERO Error - other resolutions not working
I am trying to resolve a #DIVIDE BY ZERO error. I've seen the other resolutions, but they are not working for me. Here is the formula that I am using: =ROUNDUP(([Anchor Install Hours]@row / {Amazon - Brownfield - Priority Sites - Set Range 2} / [# Anchor Technicians]@row), 0) I tried the IFERROR(ROUNDUP resolution and that…
-
Cartesian Product
Hi Everyone, I have two sheets that I want to merge into a 3rd sheet and want to create a cartesian product in the 3rd sheet. I can't find a way to get this done, has anyone tried this before? Thanks
-
Adding an ISBLANK
Hi there, I have my formula that works but forgot I needed to add a clause for when a column cell is empty so it doesn't return an error, which I'm hoping will allow me to make it a column formula without too much fuss. I'm trying to use ISBLANK as that seems like the best option and I just can't see the problem but it…
-
RAG = Date Range formula?!
Hi, I'm setting up a sheet to keep a track of training and re-training needs. I need the RAG status to change according to the date range, e.g.: Person A | Training Due Within 90 Days of Today | RAG = Yellow Person B | Training Due Anytime Over 90 days from Today | Rag = Green Person C | Training Overdue from today up to…
-
Looking to see the Sum based on what is in another column
We are trying to move all of our excel sheets into smartsheets and we have one sales tracking sheet we are looking to have automated. The columns are Salesperson, Month, Expected Sales. What we want to see if Month equals March what is the Sum of the Expected Sales for those Salespersons. We want to have this automated so…