-
Conditional Formula with Date requirment
Im having trouble combing a conditional formula. Both parts work on their own but when I try to join them it breaks. So far this is what i have =IF(AND([FINISH]1< [Go live Date]1), IF(Status1 = "In Progress", 1, IF(Status1 = "Not Started", 1, IF(Status1 = "At Risk", 1,0))))) I'm trying to do a numerical count. If the…
-
I am trying to create a % complete at the top of my progress column
I am trying to report out the % complete by category based on whether we are completed, or not. the column is a drop down column - I’m trying to consider “completed” and “N/A” as completed and "blank” and “in progress” as not completed. so in the first column I would only be 36% completed - 4 out of 11. but in the last…
-
COUNTIF matching two criteria
I'm trying to count if, a row matches two criteria: The row status is not "completed" (in another column) If the current date is greater than the value in another column: "Due date". So example: Clean Bathrooms Not Completed 12/1/2020 The above row would be counted on the formula because it's not completed and past the due…
-
Adding Contains to My Formula
Good Evening Smartsheet Community: I am trying to count the number of Fail that Contain FSA in the Key, but I can not seem to get the last part of the Formula Correct. Current Formula: =COUNTIFS({Test Env}, "Prod", {Test Status}, "Fail", {Key}, CONTAINS("FSA")) Thanks
-
Join a Parent Name with a Child
Hello Smartsheet Guru's I have a primary column with Story (Parent) and Tasks (Child) Another Column has Story # - pre-assigned from a vendor. I want to be able to append a unique number to the task # with the Story Number. So layout Primary Column Story 1 Task 1 Task 2 Second column Story # ABC-1 Third Column - I would…
-
How to get average per person from the form submissions?
Hi, I've created a form and workflow to notify a specific group of persons just once new form gets submitted and all that works just perfect. I am now trying to get an average per person from all the submissions to see an overall "rating" and this is what I want to email to a specific person weekly. Can anyone advise how…
-
Formula to count specific month
Hi, I'm trying to count a number of projects for a timeline creation. I need a formula to count a project that started in a specific month. My current formula does not work :( this is my formula =COUNTIF({Project Type}, "Non-infra", {Project or Milestone}, "Project", {start date}, >=DATE(2020, 1, 1), AND({start date}, <=…
-
Formula and Inserting reference to report to a summary page
Hello! Thanks for stopping by I am getting a lot of use out of this community page. Thank you all for the help! Now to business. I am working on a recruiter tracking sheet. I need to be able to paste into my source sheet and have the sheet talk and push my data to the appropriate reporting spot. The destination sheet has…
-
Set Status Based on One or More Expiration Dates
Hello Community, I have a sheet where the primary column is a user name. Then, a status column with RYG. Then, alternating columns of checkboxes for a unique certification followed by a column with the expiration date of the certification. I would like to set the status based on the following conditions: Red = any…
-
Formula to report total tasks and total tasks completed
Hi, I'm looking for some help with the below. For the most part I'm able to make the formula work, however I'm unsure how to account for Friday. For example today is Monday, but the formula only reports Sundays data (nonworkday). Also all of my formulas are in the Sheet Summary, as I'm trying to prevent any need for…
