-
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…
-
Need help with a index matching formula or next best alternative
Hello, Our dept's role is to facilitate visitors (overseas medical faculty), who are invited by the respective clinical departments chairs to our hospital. There is a lot of paperwork involved between the host department, our dept and HR. We are therefore leaning on document builder feature. But one thing, the good…
-
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…
-
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
-
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…
-
Help with formula
Hello I am working on this new formula where are trying to calculate the verification due date. The original way we were getting the value was when the date format was in a MM/YYYY but now the dates will come in a MM/DD/YYYY format when having this format the output of the formula we created for the Verification Due Date…
-
Checkbox Formula Not Working in Metrics Sheet
I am trying to make a metrics sheet that shows how many checked boxes there are in my sheet. The tutorials I found said that "true" and "false" mean whether the box is checked or not. Why are my results showing as 0? I should have at least 20 as checked. I used the formula COUNTIF({checkbox 1}, [Column7]@row) This was…
-
Creating a Perpetual Quarterly and Yearly Count
Hello All! Any thoughts or help would be appreciated. I am trying to use my Month Renewal Date to create my Quarterly Renewal Date. However, my formula is not providing an out put. =IF([Month Renewal Due]@row = "November", "Q4", IF([Month Renewal Due]@row = "January", "Q1", IF([Month Renewal Due]@row = "February", "Q1",…