-
Alert based values in two columns
Hi, I have a total inventory column and a reorder point column. I'm trying to make my sheet alert someone when the inventory falls below the reorder point. I can't seem to figure out how. I know I'll need a helper column. I thought I'd do a check box and then have the alert set to when the checkbox is checked. But I can't…
-
Multiple Criteria, total count
Hi All, I am trying to do calculate a total number of events, that match criteria for 1. Date range (can also use fiscal column as a matching criteria where i only want those that contain specific letter/numerical value = Q2) for all -NDA Webinars. I don't want it to count each column that matches the criteria, but if the…
-
SUMIF Not Working
Hi, I'm running into issues when trying to use as SUMIF function in my sheet summary. I need to have it add together all the percentages in the red square under the column "Capacity Rating." The goal is to be able to create a SUMIF for each project manager in the division so we can see what their workload capacity is…
-
Moving rows to new sheet with proofing enabled
It is very inconvenient that I am unable to move rows that have proofing enabled to a new sheet (keeping the proofs intact in the new sheet). We have purchased a new company and we need to move those company-specific rows to a new SmartSheet (including the proofs) but we are unable to do so. Is there a work-around solution…
-
Change Management: Multiple projects > Consolidate into one
Hi there, I have multiple change projects to track within the general IT PMO along with other non-change projects. My goal is to consolidate them and list them underneath the 'change' category and so I'm trying to figure out the best way to organize them without listing them all out and clogging the other non-change…
-
Creating a formula that looks for criteria in a range and searches for that combo in a row
Hello, I hope I explain this the right way. I want to to find if a specific (row-level) combination of employee and date that exists on the first sheet also exists on the second sheet and if so, use a formula to flag the row that has the combination. For example, if Alex and 06/16/20 exists on the first sheet, I want to…
-
SUM IF Name and Points
I need to calculate the total number of points in the "Points Column" by each person in the "Name" column and I cannot figure out how its calculated. I tried to brainstorm with another co-worker and we both had trouble trying to figure this one out. Please advise.
-
How do I calculate IF statement to multidrop down list?
I can trying to get my sheet to calculate different values based on what is selected in the drop down. Example: If "Partner introduction" is selected populate 10 points in "points earned" column and $1 in the "dollar value earned" column, If "Quote Request" is selected populate 50 points in the "points earned" column and…
-
Roll up of assessment data with conditions
I need to be able to roll up associated transmittal #s to 1 Transmittal and if the assessment status is Not Compliant for any of the Compliance Assessments then Transmittal 1 should equal Not Compliant, Transmittal 2 = Not Compliant, Transmittal 3= Compliant
