-
I need help with a IF formula with a check box
I want to create a report of all my orders that are ordered AND verbally confirmed, but when an order is only verbally confirmed I want a star to be next to the order. I have a date column that notes a verbal confirmation. I also have a date column that notes an order date. I want the check box to check IF there is a…
-
Formula help please
Hi community - I am using this formula in the 'Planned progress' column of my projects: But it returns more than 100% when the date is past todays date (see example below). So I need to add to the formula - if today's date is after the planned end date, the planned progress should always be 100% (and never more than 100%).…
-
COUNTIFS across sheets
Hi, I am trying to pull data from two sheets into one, where it will be used to support reports. Is this syntax correct for this? I'm getting the incorrect argument set error. =COUNTIFS({JDP Attribute}, "Safety & Reliability; 1.1 Reliability of gas service", {2022 CSAT Comms Range 2}, "Safety & Reliability; 1.1 Reliability…
-
Help with multiple IF formula
Hi, I am wondering if someone can help with a formula please. I have two date columns which lookups to a cell and gives it a start date and an end date. Which is usually a start of the month and end of the month date. I need a formula that looks at 'Date Completed' and if it is within the start date and end date then it…
-
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…
