-
Can you add in criteria that uses contains in a SUMIFS formula?
Right now here is my current formula: =SUMIFS({(Template) Channel Monthly Plan Range 1}, {(Template) Channel Monthly Plan Range 1}, >0, {(Template) Channel Monthly Plan Range 6}, "Victoria", {(Template) Channel Monthly Plan Range 4}, >=DATE(2021, 2, 1), {(Template) Channel Monthly Plan Range 4}, <=DATE(2021, 2, 28)). Works…
-
Adding total number of drop down options selected
I am having trouble with finding a formula that will count the total number of each multi selection drop down option in a sheet (Error type). I am tracking error types and need to have a monthly sum of each error type: Wrong Laterality Order Type Error (Commercial vs WC) Misspellings/Cross outs Sx order missing…
-
How to create a line chart in a dashboard?
Please read carefully! I want to create a line chart in my dashboard. I have 2 years worth of counts broken out by quarters. I want each year to be it's own line in a line chart. Any idea how I can create this? Currently, it's all 1 line. Thank you in advance. SB
-
Countif not working?
Hello, I'm using a simple countif function: =COUNTIF([Ahead/Behind Schedule]2:[Ahead/Behind Schedule]11, "*Ahead*") in hopes that the result of all the tasks that are Ahead of schedule. However, I am getting a result of zero though I have one cell that does have this in the cell: 28 days Ahead Anyone see an error in my…
-
Calculating weekly/monthly totals by dept
I am using forms for input on a calendar to track how much time is being requested of the workforce by different departments. I know what form fields I need. But I am needing to figure out how to calculate the weekly & monthly time commitment by the Request Originator. I am not sure the best way to set up my sheet to show…
-
Can I publish a dynamic view to anyone outside of our organization?
How can I make a dyanmic view available for external people so they can access data from an inventory and can filter sections?
-
Formula for health status of overall project
I was using the below formula to provide the health status of the overall project, but its not working. The result (green, yellow or red) is supposed to come back with the majority of the tasks that are in that color. In doing my test, most of my tasks were in red status, but the result for the overall project came back…
-
How to create a workflow/formula to reference a cell when the conditions are met in the same sheet.
All details are in the attached file. Many thanks in advance!
-
VLookup/Index+Match to get second or third match?
Hello, I apologize if this has been asked before but I'm struggling to find a solution that works. I have two separate sheets, one that catalogs all computers in our organization and the other is a "master inventory" sheet. I can use VLookup and/or Index+Match to retrieve the first value in the computer inventory sheet…
-
SUMIFS and Exclusion formula needed
Hello, I am very green to SmartSheet and hoping to find some help here... I am looking to write a formula referencing another sheet that will spit out the total (SUM) from one column, provided (IF) another column is a certain value, and yet another column (IFS) is NOT a certain value. I'm having trouble figuring out how to…