-
#NO MATCH when counting the results of a VLOOKUP
I am trying to count how many items fit 2 criteria, one is the year, the other is the state. The issue is coming in with the state, as I just changed it to a VLOOKUP and my formulas were all working before I did that. The VLOOKUP is working, but there are a few values which return a #NO MATCH and I can't change that due to…
-
Combining multiple SUMIFS into one formula
I have used and tried each of these formulas separately and they work beautifully. =SUMIFS([Total Savings]@row, Lane@row, "IL5" =SUMIFS([Total Savings]@row * 90 / 100, Lane@row, "IL4" =SUMIFS([Total Savings]@row * 50 / 100, Lane@row, "IL3" =SUMIFS([Total Savings]@row * 10 / 100, Lane@row, "IL2" =SUMIFS([Total Savings]@row…
-
Automatic "Cell linking"
*What would be the best way to create a permanent link between cells. What I want is that if the user knows one of the bits of information, i.e. "WXP" that the other 3 cells get filled in automatically. We basically develop real estate and the project might start out known as the "Nome project" and gets assigned a Project…
-
IF AND Formula Workaround
Hi All I am trying to get a formula working whereby if * END DATE is in the next 3 days * END DATE is not blank * Status is either (In Progress, Not Started) * At Risk flag will be indicated (, 1) Many thanks
-
Nested IF(AND OR(IF(AND Statement
I am trying to identify which projects need committee review vs those that can be auto-approved. I have 5 columns with the following selections: - Currently Underway? - Checked/Unchecked (I want values that are unchecked/=0) - Helper - Timeline - Returns Yes/No based on formula. (I want values that = Yes") - Helper - Count…
-
Help with #DIVIDE BY ZERO error message
Hello, Hoping you might be able to assist me with a similar issue I'm experiencing. I've attempted to import a Trello board into Smartsheet for one of my colleagues and I'm getting the same error message, when I view it in grid view on some of the rows. The formula in question that is currently being used…
-
Generate reference after box ticking
Hi all, Been trying to look for my solution here, but i can't seem to find it. Hopefully someone can help me. I have a supplier approval database with supplier info, several checkboxes for required docs, etc. Also have an approval column, and then an approval reference column. What i intend to do is, when i tick the…
-
Can I link an entire sheet into my master sheet?
It looks like I need more than Cell Linking in our master project tracker. Do we have the ability to add a section on our master sheet so that any updates from a separate MARKETING TEAM sheet is displayed in the master sheet? I'm afraid simple cell linking only focuses on cells and won't take into account additional rows…
-
Adding an additional requirement to a formula
We have been using this formula to add up the hours spent working specific clients -- been working fine. We have also been asking what category of work they have been completing at these clients but haven't been utilizing the data. =SUMIF({Kinsman - Job#1}, [Scope of Work]@row, {Kinsman - Hours#1}) I now need to add an…
-
VLOOKUP cross-sheet, if the search value's parent = @row
Hi all, I'm trying to populate an entire column on a sheet using both cross-sheet and in-sheet references. I'm trying to return a value according to the following logic: Looking for cells cross-sheet that contain "Opening Date" and returning the value from the cell to it's right (also cross-sheet) if that particular…