-
Automating a way of understanding time difference when start and end time are in the same column.
Hi everyone, We are looking at using a smartsheet solution to understand how much time employees on our production lines are spending working on certain lines. I created a separate sheet for each production line (we have 12 production lines) and I am using QR codes scanned via a smartsheet form (Quick for employees to…
-
Sort data from a JOIN(COLLECT( formula within a cell
I have a formula in one of my sheets that looks out across multiple columns and populates the cell with all values present in the columns for that row. I simplified the column names to make it easier to read, but here is the formula: =JOIN(COLLECT([Data1@row:Data5@row, Data1@row:Data5@row, <> ""), ", ") My question: Is…
-
Project Approval Received / Master Project Sheet Populated
I'm trying to setup an intake process where a new project is submitted through a form and appears within a project intake sheet for review/approval/denial. If approved, I'd like certain, if not all, column values for new projects to be copied over to a master sheet, which includes additional columns for project charter and…
-
#INVALID DATA TYPE
Hi, I am using the following formula that calculates the # of days between a date field and TODAY(). I have an issue if there is no date in the field and giving an #Invalid Data Type error. I would like it to either be blank or if possible to say "Please provide a Date" Formula =NETWORKDAYS([Lease Stage Date Changed]1,…
-
Is it normal to count empty rows when selecting the entire column?
I have a formula that looks like this: =SUMIF([Request Status]:[Request Status], "5-Complete", [Est Days to Scan]:[Est Days to Scan]) I've noticed that in each of the two columns referenced in my formula, the selection includes 10 rows of blank cells below the last populated cell. Is this normal?
-
Bug or Feature?: Used in Formula does not display for Contact List
Title says most of it, so I'll repeat it: Bug or Feature?: Used in Formula does not display for Contact List Hover over the [ContactList] column which is referenced by formula on the destination sheet does not ever display the "Used in Formula ... " pop-up. I did not see anything in the Help articles to indicate this is a…
-
Sumifs question
Failry new to Smartsheet, I can do this so easily in Excel, but not in Smartsheet. I'm basically trying to add an amount requested based on whether or not the request was approved. The approval is a dropdown menu with only 3 text status - Submitted, Declined, Approved. I want to add the Request Amount column and only the…
-
Counting a date diffrence with children
Hello, Does anybody know if there is there a way to make the below formula work? I'm not sure what I'm missing. I need a count of children where the difference between the task due date and the created date is 1 or less.This one has stumped me. =COUNTIF(SUM(CHILDREN([Due Date]8) - CHILDREN(Created8)), <=1)
-
Some Results are not showing from my formula
=IFERROR(SUMIFS({# tags}, {TaggedBy}, Employee1, {QAedCebu}, MONTH(@cell) = 10), " ") Formula Breakdown: (Reference Sheet A contains all tags, dates and employee assignments, Sheet B is the sheet I am trying to create totals on) # tags = Number Column (ref to sheet A column) TaggedBy = Employee Name Column (ref to sheet A…
-
Help with countifs formula
I am a bit new to complex formulas so hoping someone can help. I am trying to add a column on one sheet, that falls into two basic categories on the same sheet. The formula I am using is as follows =COUNTIFS({MM Non Prod Issue Tracking System}, [Distinct System]@row, {MM Non Prod Issue Tracking Days Old INT}, <=30, =[down…
