-
Due Date based on Priority and Date Submitted
Hi, Was just after a bit of help with a formula I am trying to produce. We have a sheet with a column 'Priorities' of Low, Moderate, High, Extreme. We then have a column titled 'Date' I am trying to automate our 'Investigation Due Date' by IFS formula. That is priority is Low or Moderate the Investigation Due Date will be…
-
Update status field based on End date and %completion
Hello All, I would like to do some conditional updates in smartsheet based on below: 1) I want status field to reflect Green if End data of task is greater than today's date 2) I want status field to reflect Red if End data of task is less than today's date and % completion is less than 100%. 3) I want status field to…
-
If & AND equals checkbox
Cant get my formula to work =( Please help =IF(AND([Team]28 = "Street Lighting", (NOT(ISBLANK([Quote Sent Date]28)), 1, 0))) If Column 1 (Team) contains text "Street Lighting" and Column 2 (Quote sent date) is not blank, Check the box Thank you in advance
-
Filtering Older Data
I was wondering how to use smartsheets to filter out older data in a log. For example in a purchasing log, what I did at first was creating a checkbox column with cells such that a order that arrived for longer than 2 weeks will be filtered out: =IF(AND([Last Modified]1 < TODAY(-14), Status1 = "Arrived"), 1) That function…
-
SUM IF & LEFT @cell
I keep getting the result of 0 I am trying to sum a range if another column contains "Street Lighting" I have tried changing the text reference from the entire column, to particular range and adding the LEFT @cell with and without #(5) see below. =SUMIF(Team:Team, LEFT(="Street Lighting", [Days to respond]2:[Days to…
-
Rule Creation Help Needed!
Hello - I am managing a Smartsheet action item log. I need any row that is deemed 'complete' to be moved down into a completed section further down the sheet. Is there a way to set this up to be automatic vs. manual?
-
Need help with a formula
here are the formulas and a look at the Spreadhseet. The Column labeled Column has the following formula =SUM((COUNTIF(CHILDREN(Passed10), 1) / SUM(COUNT(CHILDREN(Passed10))))) The current formula in the Status column for the Exception Rules row10 is =IF(Column10 = 1, "Pass", IF(Column10 = 0, "Not Started", IF(Column10 <>…
-
#INVALID DATA TYPE
Hi All! I have two cells next to each other, Date Assigned and Date Due. When I add the date assigned date, I want it to auto populate the Date Due as 3 business days in the future. My formula works =WORKDAY([Date Assigned]86, 3) but when I have no date in the Date Assigned cell, the Date Due says #INVALID DATA TYPE. Is…
-
Specific Dates in Columns
Hello, I have a column that users must input a date that their project will attend a specific meeting. This meeting only happens on set days every month, so I am wondering if there is a way to only allow a user to choose/put a specified date in the cell for that meeting. For example, if that meeting happens on August 9th…
-
If / Or with RGYG
Hi All I am trying to write a formula that shows whether a student is competent. Some units have 3 assessments (A, B, C) and some have 4 (A, B, C, D). I am using the Grey ball to show no assessment or N/A (for the units that only have 3 assessments). * 3 assessments - A, B, C = green and D = Grey then the student is CO,…
