-
How do I create a report from various forms?
Ok, so I have about 17 forms created for various employees in different departments. Each employee is required to fill out this form x amount of times a month. I want to make a report to auto populate that shows how many times employee filled out the form, and I want the report to show the employees percentage of completed…
-
Automating count formula and trend summary
Hello All, I am wondering if there is a way to automate this process. I am trying to get a count of each line item status type at the end of each day. Currently, I am updating a master sheet that has a status column reading either “active” or “not active.” At the end of each day, I am manually totaling the number of active…
-
Best way to look up multiple values in a multi-select cell?
I have a schedule that contains tasks, and each task has one or more cost codes associated with it. These cost codes are in Dropdown (multi select) cells. For each cost code in a cell, I would like to look up the associated value and add the values together if there are more than one. I am not sure the best way to do this.…
-
Using LEFT Function with Countif
Hello, I receive a data from other parties that is formatted inconsistently. The column of interest is labeled Target Months and ranges from things like "36 Mo.", "12 mo" and "1Mo" etc. I am only interested in the number since I know it is referring to months. Using the LEFT function I can strip out the 36 and 12, however…
-
Average Collect Formula Not Calculating Correctly.
Hello, I am looking to determine the average time based based on start/ completion dates, location and the frequency in which the activity occurs. However, it does not seem to be calculating based on my criteria. Could anyone help me determine why the average is not calculating based on my criteria?…
-
If nesting... in a true/false - FOUND IT! Remove the 0 in the nesting
I can't figure out why combing these statements isn't working. This works: =IF(AND(CONTAINS("Director", [Approvals Needed]@row), CONTAINS("Lead or Supervisor", [Approvals Needed]@row), CONTAINS("Manager", [Approvals Needed]@row), [Lead or Supervisor Approval]@row = "Approved", [Manager Approval]@row = "Approved"), 1, 0)…
-
Last 7 days
I am trying to create a formula that will pull data from two columns in the sheet as follows: Sheet columns include intakes by location and a date entered column. I want to create a roll up at the top to show intakes by location in the last 7 days that automatically updates. Here is what I have:…
-
Please Help SUMIF Question with Parents and Children
I'm working on a project sheet with dozens of Parent rows, each with a various amount of Children, ranging from one to over twenty. I have a user inputted column to assign known work hours needed for each Child's job, and am trying to create an independent running total for each Parent/Child group. This will allow me to…
-
VLOOKUP returning wrong value - solved
I had the following post ready to go, but figured out the problem. I'll still post to help anyone else. Essentially, when the VLOOKUP final parameter is left to default (true), Smartsheet thinks that "Low" is close enough to "High" to return the value for "High". When I change the final parameter to false, it returns the…
-
Nested IF/OR Contains Function
Hi, I'm trying to write a CONTAINS formula to auto-populate the project location column. There are 6 states to choose from. The Project Name is usually very long & descriptive but always contains the standard 2 letter code for the six states that the projects could be in. I came across the CONTAINS formula but cannot…