-
Rolling 2 week task count
Hello, I am trying to do a cross sheet formula that counts the number of tasks that are not complete and have a due date in the next 14 days for a specific department. I hope I am close but it is coming back as unparseable. Could someone please review and tell me where my mistake is? Please find my formula below.…
-
Bold a row if name matches name from other sheet
Hello, I have two sheets. Sheet 1 has a list of organizations and I need to check a box if they have received funding from us. Sheet 2 has a list of organizations we have funded in the past. There are over 100 organizations. What would the formula be to say if the organization name on Sheet 1 appears on Sheet 2 check the…
-
Sum cell from last row - multiple sheets
Hello. Looking to sum a specific cells from multiple sheets. Have 5 sheets. Columns are the same across all five sheets. Looking to take the last entry, say for column 1, across all five sheets and sum those values. That value would live in another sheet. Any ideas? Thanks Shawn
-
VLookup with IF statement
I am going to try the out of spec condition using VLookup. I am not sure this is possible. But here we go. This log has entries that will VARY but do have upper and lower limit specs. However, in the same stage one substrate may have a different u/l spec sujch as seen here with CRS UPPER limit of 175 and all others have…
-
Common status: Parent/Children formula
I need a formula in a parent row to return the most common value of its children: If there are equal or more reds than yellows or greens, the parent status should be red. If there are equal or more yellows than reds or greens, the parent status should be yellow. If there are equal or more greens than reds or yellows, the…
-
Nested IF formula
I am attempting to count cells that have text or not and using this formula: =IF(SUM(IF(SUM((IF(ISBLANK([T2 Last Name]@row), 0, 1) + IF(ISBLANK([T3 Last Name]@row), 0, 1)) + IF(ISBLANK([T4 Last Name]@row), 0, 1))) + (IF(ISTEXT([Last Name]@row), 1, 0))), 0, "") If the cell has text I want it to count 1 - if not then 0 and…
-
vlook up
Hi, I'd like assistance in creating a vlook up formula. So I would like the sheet to vlook up and find the date of birth and postcode from a different sheet when the name matches. See attached image of how the sheet where the vlook up needs to be added is set up. I have got the same columns and names set up in a different…
-
How to get the max value in a column based from distinct values in another column
Hi mates. Can you please help me to get the max value in a column based from distinct values in another column? For example is like this How to find the max value of "Car" based on the left table? Please kindly help me, this is urgent.
-
Capturing a Total Count to display in a Dashboard
I am trying to capture the total number of active projects found in a specific Workspace. Each project is its own, separate, SmartSheet. The way I am able to do this now is by manually creating a Formula (COUNTIF({Proj Name Range 1}, "Yes"),in a separate SmartSheet, and then creating a Metric Widget within the Dashboard to…
-
IF Functions and Dates
Hi All, I am trying to use an IF function with dates. For example, IF a date is less than 15 days, return green, less than 30 days, return yellow and more than 30 days return red. When I tried typing this function in using the correct symbols and true/false values, I get an error message. I am creating a log of requests,…