-
Index matching formula for cross referring between sheets
Hi everyone, I would like to get help with a formula related to index matching. I have two sheets, for the purposes of this discussion - Sheet A and B Sheet A (only has these two columns) Sheet B is a grid view sheet that has a Smartsheet intake form. My ask is - When the intake form is submitted, if Dermatology - Dr. Ozog…
-
Help with revision of Nest IF Statement for Symbols
Need a revised formula, which is in the Certification Complete column. This worked great. However I was just made aware of something. Okay, @dojones provided a perfect solution. However, as we are all aware, we are not always told about all the pieces of the puzzle. that solution was: =IF(AND(ISBLANK(Certify@row),…
-
How can I get specific information once its put into my base sheet, into multiple other sheets?
I have a request sheet that people will be submitting information into. Based on that information, I want one core column to be cross referenced into other sheets. Essentially that column will just be a task number, 001, 002, etc.. Once someone submits a something into that sheet that gets auto populated with the task…
-
Help putting data in the correct column automatically
Hello. I'm working with a worksheet where I'm trying to put a Workers management team into the correct column based on the Managers Management Level. I'm able to see the flow of an organization by using an INDEX(MATCH()) formula (=INDEX({Manager}, MATCH(Worker@row, {Worker}), 1), but how do I get the data to show up in the…
-
Why am I not getting the same average value in my formula compared to the sheet?
My formula shows average of .3625 (rounding up won't even help) The sheet shows average of .97 (which is correct). The values outlined in blue are MS
-
Index(Collection formula for dropdown field with multiple entries
Hi Team, I know I am asking a lot but if anyone knows it will be this group :) I have a dropdown field that allows multiple entries - for example sales blockers These blockers can be grouped together to give a blocker group. I've used =INDEX(COLLECT before but not sure it will work for multiple entries any ideas if I can…
-
Error In Filtering Parent Row Formula
In my metric sheet, I am receiving the #INCORRECT ARGUMENT SET error on code I made trying to only count the child rows in my reference sheet. =COUNTIFS({Is it implemented?}, 1, {evidence attached 1}, "Yes", {Parent?}) I wasnt sure what part of my reference sheet I was supposed to click on to add the "Parent?" part, so I…
-
No Match...but the formula works
Can someone help me with this? I have a formula which works but it's finding NO MATCH for two lines but I don't know why as the formula has no problem finding a different line on the same sheet… This is the formula: =IFERROR(IFERROR(IFERROR(INDEX({IQA Log Record Closed?}, MATCH([Primary Column - IQA Ref]@row, {IQA Log IQA…
-
Perpetual Contract Renewal Formula
Hello All! I am trying to create a formula that will automatically update the end date to a contract based on a renewal timeframe. For example, Contract Start date 12.31.19, Contract end date 12.31.20 at the end of the contract, the contract will renew for 1 year perpetually on the same date. Right now we are at 11.8.24,…
-
COUNTIF
I am trying to COUNTIF range 1 is yes then range 2 meets any of 3 criteria. A single criteria works =COUNTIFS([Current Status]:[Current Status], "Active", [Milestone/Deliverable Name]:[Milestone/Deliverable Name], "Parent Project") I need to add two additional criteria for the same second range. I want it to also count if…
