-
SUMIFS to Calculate Values for a Specific Year/Date Range
I am trying to use SUMIFS with multiple criteria, and I am failing horribly. I seem to be having trouble when I try to add the criterion to sum data from a specific year (from a Date field) and/or when I attempt to add data from a date range. I have searched the community questions, and I haven't been successful in finding…
-
Managing different Holidays calendars
Hi, In my schedule, I would like to manage different holidays calendars associated to different department. In this example, I have 2 Departments to manage : "Dept1" and "Dept2" I have created a specific "Holidays" sheet to manage the different holidays for each departement with a date column called 'Dept1' to list all of…
-
Multi Select Dropdown Witih Criteria pulled from Another Smartsheet
Hello! I am attempting to create a Smartsheet form. When a user completes the form they need to identify every account that will be impacted by the project associated with that form. How can we include a multi-select filed in the form, with which all accounts to select from are included in a separate smartsheet list? is it…
-
Count children rows by status
Hi - I have a sheet with parent rows and children rows. Each child row is associated with a status (Not Started, In Progress, and Complete). For each parent row, I'd like to count the number of child rows that are in each status. I need to present this information in a dashboard . Ideally I would create a separate summary…
-
VLOOK to a diffrent sheet #NO MATCH
I'm getting the #NO MATCH error when cross referancing to a nother smartsheet file that has close to 20k rows, do you think this is causing the error. I looked up one of numbers and see it but still getting the #NO Match error. It is not finding any of my 500+ rows? Any thoughts here? First image is teh {Smartsheet BNI BU…
-
CountIF Symbol & Between 2 Dates
Can someone help me with a formula that would count all the "Flags" in the "Work Related Exposure" if the "Created" date is between two dates ("Encounter Date" and "Date Resulted")?
-
Multiple IFs Statement: Number to Name
We currently use numerical codes to denote our teams that are synced from JIRA. Those numbers are reflected in a column which I'd like to translate into the relevant team names. Team Column: 107 = IT-HelpDesk 108 = IT-EnterpriseApplications 109 = IT-CorporateInfrastructure 110 = IT-ProjectManagement I'd like to create a…
-
Get a distinct set of values from an existing column without changing order.
Hello, I am trying to get list of values that has each value only once. Below I have my JOB NUMBER column and I am trying to create an automatically updating column that we will call DISTINCT NUMBER that lists each number once. The catch is that the JOB NUMBER column is always changing and I want the DISTINCT NUMBER column…
-
VLOOKUP Based on Name and Date
Hello, I am having some trouble with a query allowing me to look up values based on the name of an individual AND within a certain date range. The data table is weekly updated with new values, and has multiple fields, including name, date and comments. I need to pull a comments field, based on name and date. Thank you in…
-
Add
I have 3 Sheets: #1 = Closeouts, #2 = Annual Incentives; #3 - Incentive Distribution When a closeout is completed, data is entered on Sheet#3 - Inc. Dist. I have a Data Mesh to pull the data from the # 3 to populate Info on #2 Ann Inc. I am trying to get a formula or function that will do the following: When an entry is…