-
Auto number risk column only adding till row 20 to another sheet reference
Dear reader, I came across a unique issue and need a help. I created a 'portfolio sheet' with list of projects in one column and a next column for Risk ID with text single line I created a separate sheet 'Risk register' with a dropdown of all the projects similar to the portfolio list and added a Risk ID column with #Auto…
-
HELP What am I doing wrong in this formula?
=INDEX(COLLECT({Unit/Manager List WI Range 1}, {Unit/Manager List WI Range 7}, [Area of Study Parent]@row, {Unit/Manager List WI Range 8}, [Area of Study - Nursing]@row, {Unit/Manager List WI Range 9}, [Area of Study - Radiography]@row, {Unit/Manager List WI Range 10}, [Area of Study - Rehab Services - PT/OT/ST]@row,…
-
Formula Question for IF(AND(NOT(ISBLANK(
I have a sheet that contains book information and want to index/match date from another Smartsheet as long as the date in the column called Most Recent Available Date@row is greater than today AND InventoryID@row is not blank. If either of these is not the case, then I just want an empty cell. Here is the formula I…
-
CountIf between two numbers
I would like to count how many people scored between 99.5 and 99.9. Here is my formual. =COUNTIFS(Janury2:January12; >=99.5; January2:January13; <=99.9)
-
Find Matching cells between 2 sheets
I need to find cells that match each other on 2 sheets and display them on a 3rd sheet, but the displayed cells have to be in the last 14 days of a date column on one of the original 2 sheets.
-
Use Row@row to reference the row above in a column formula
I'm attempting to use Row@row along with an Auto Number column, in a column formula, so I don't have to manually update the formula when rows move within the sheet, but am not having any luck. The formula in the Est. RU Date column is RU Date, if it is populated, otherwise it should take the date in the Est. RD Date column…
-
Formula to count multiple cell values and their dates
I am looking for assistance in creating a formula that will allow me to isolate values in the Provider/Resources cell, the Type cell and count based on Visit Date. Below is the a snapshot of the sheet. As you can see, there are multiple names in the Provider/Resources column, as well as the Dept column. The first name in…
-
Can I have just one cell automatically copy over from 1 sheet to others when a new row is added
I know there is a workflow for copy row if row is added or changed. I don't want that, since it will copy all of the columns. I have 1 Master List of Names. The other sheets are specific trainings and prerequisites. I will have columns on the master list that don't need to be on the other sheets, and vice versa. I figure I…
-
Subtotal based on a filter in the Grid view
Hi, I am trying to subtotal a number column based on the data returned when a filter is applied in the Grid view? I have tried the obvious subtotal() formula but this does not seem to work, can anyone please help me with this? Thanks
-
Weird issue - COUNTIF Date Cross-sheet Reference
Hi - I'm doing a very simple cross-sheet reference for a count of dates and it's not working. Sheet 1: Date column has a series of serial dates. Column14 has a formula that is not working. Sheet 2: This has a Date Completed column. The formula in Sheet 1 in Column 14 is: =COUNTIF(Date:Date, {BPD-DateCompleted}) - ...where…