-
Formulas and functions for tracking delays
Hello! I would love some guidance on if there are any formulas or functions that are useful for tracking delays with a project. More specifically, our organization is hoping to track who was responsible for the initial and subsequent delays with a project. In our sheet, we have columns for: Task, Assigned To (Dropdown),…
-
Splitting multiple form answers
I've seen a few workarounds for this, that usually require another party or app. I've also seen "basic" formulas using INDEX, for this, but as someone who is VERY new to Smartsheet, I'm hoping for some additional guidance. I created a form, essentially for class registration. Sometimes people sign up for 1 class, sometimes…
-
Need to find the whether the task done on time or not with DATE + TIME Functions
3 Teams handle this Deadline, 1 day each. Total Deadline 3 Days. Each day 24 hrs deadline. Ex: Received Date/Time 06/08/26 7 PM to Due Date/ Time 06/11/26 7 PM. ( 7 PM is not fixed irrespective of time, but we need 3 working days as deadline not 7 days - Mon to Fri) 1 Scenario: Team 1 If Received Date/Time has text value…
-
COUNTIFS formula kicking back wrong number
I'm looking to get the total number of docs submitted that had an error, so a row count of items that aren't 0 in the error lines column based on Indexer Identifier Number and the formula I made works, but it kicks back 5 instead of 2. I'm not completely sure what i'm missing in the formula to get it to kick back the…
-
Best Way to Create a Stacked Bar Chart from multiple columns
I have a sheet that I pull into a report. The report I then want to use to make a stacked bar chart and put into a dashboard if I can. The columns I am trying to make into a stacked chart are: Lead, project and phase. The issue is that there are several leads and I need the stacked bar chart to show in different colors for…
-
Sum Multiple Drop Down Selections
I have a Smartsheet with a drop down cell that I can select each employee working on a task. Each employee has an efficiency rating from 1 to10 on another sheet. I want to be able to sum the ratings for each crew into a single cell. I have spent hours looking for a formula to do this with no success. I appreciate any…
-
Sheet Analyser - What would you like to see?
Hi, I'm creating a sheet analysis dashboard with the API that will provide a detailed breakdown of any issues on a Smartsheet sheet, so that admins can improve their sheets and head off any potential issues. Some of the things I've already added warnings/information for are: High row, column and cell counts Broken formulae…
-
Counting occurrences of drop down menu selections
Hi all, I'm looking for a COUNT or COUNTIF formula to total drop-down menu selections within a given range of cells in a column range. The attached shows the DD menu with trusses selected. Our sheets are broken into calendar months, sometimes with over 100 entries for that month. Not every cell within that column has…
-
Formula to Flag Duplicate Values
Hi - I have been trying to create a column formula that will flag duplicate values in my [SKU] column while leaving the first occurrence unflagged. Some of the values in the [SKU] column are either Blank or "TBD" so I would like to ignore those values. My ultimate goal is to be able to filter my report from this source…
-
Formula to subtract one month from a date
Hello. I need to subtract one month from a date. I have tried =Date-30, and then minus 60, etc. By month minus 5, I was quite a bit off from the first of the month. If the Date being evaluated is say 4/1/20, I'd like the first calculation to produce 3/1/20, and the next row to produce 2/1/20, and so on. I did find a…