-
How to calculate days between two dates
I'm using NETWORKDAYS to exclude weekends, however, I'm getting an "Invalid Data Type" error. Both columns are date columns. =NETWORKDAYS([Date of Verbal Agreement]@row, [Module Go-Live Date]@row) Thanks for your help!
-
Subtracting Dates - Smartsheet is rounding date/time up
I am trying to subtract two dates to get the duration of time something stayed within a phase. Currently we are trying to use "CreatedDate," the auto-generated field as the "start" and another date field as the "finish", let's call it "Date entered Triage". The formula [Date Entered Triage] - [Created Date] works great for…
-
Check a box when a match for a value is found on another sheet
Hi everyone, I have a sheet called Parts Database used to track parts as they go through a production process. Screenshot below. Currently, workers check off the status of each part as they go, which is not practical with the quantity of parts. Ideally, I want them to be able to fill in a response form at the end of the…
-
Help with IF, OR, NOT, ISBLANK
Hello, I'm trying to get it to check these columns and if even one of them is not blank, then populate "1" into the column: =IF(OR(NOT(ISBLANK([WHS: Enter Date Received]@row)), NOT(ISBLANK([WHS: Enter Lot]@row)), NOT(ISBLANK([IQA: Inspector Email]@row)), 1, 0)) I keep getting the #incorrect argument error.... Any tips?…
-
# of tasks based on due date and owner
What Smartsheet formula would be best to get the count of tasks due within 10 days if the owner equals "client"?
-
IF/AND formula that looks for multiple entries
Hi, I am trying to create a IF/AND formula to return a status color based on multiple inputs. For example: IF row title "Status" equals "complete" or "cancelled" or "rejected", then column titled "RISK" (the column with the formula) should be blank. IF row titled "Status" equals "in progress", then column "RISK" should be…
-
Formula to Count Non-Duplicate values
Hi, I need to count the Non-Duplicate values in a given range. Could you please help me out with the formula. In the attachment 1 & 2 is not repeated in a range and I need answer as 2 via formula.
-
Unable to determine if a field contains a date less than today's date (involves vlookup).
Hi all, I am trying to create a helper field to allow me to generate a report of records where the date from a field in my Smartsheet is less than today's date. This will be used to call attention that an update is needed. The date field being used is a vlookup generated field from another sheet. Formula: =VLOOKUP([Code]1,…
-
Counting AVG Days
Might be a simple solution, but I've been playing around with it long enough and give up. I'm trying to calculate the average amount of days to complete a process, for example; Process Start Date End Date Process 1 09/03/2022 09/20/2022 Process 2 09/06/2022 09/16/2022 Process 3 10/01/2022 10/10/2022 And so on. What I am…
-
Automate INDEX/MATCH or VLOOKUP the first date of the week each week.
I want the "Week of" column to automatically show the date of the first day in the current week each week starting with Monday as the first day, and if "Week Of" and "Project Name" both match on another sheet where the data is being enter then I want to return the next 4 columns for the rows where the "Week Of" and…
