-
The smallest date with a specific status in the child cell
Hello community, I hope this message finds you well. I need a formula to classify as TRUE if my row has a "Not Started" status and presents the smallest start date within the cells, which in the example figure, are filled in white. However, I couldn't come up with an efficient result. Any tips or help to build this formula…
-
I want to filter data with given conditions using comma and string columns
This formula kicks back all jobs in {FM & CapEx PBR Range 1}, I want to only kick out jobs that have "Brad" listed at the project manager =JOIN(DISTINCT({FM & CapEx PBR Range 1}), ",") + ","
-
Trying to calculate a countif and contains a "city"
Hi I have a sheet that is filled out by staff and another sheet that has a breakdown of % compete for each branch. The requirement is to calculate how many power users from Calgary have completed the checklist There are 10 members in a Calgary need to find the percent that have completed the power user training. Was trying…
-
NetworkDays with IF functionality
Hi, I am trying to gather a sum total headcount for each day of the month based off another sheet that has a date range of each users visit. How do i capture the total headcount for each day a user is onsite? I have been using IF(NETWORKDAYS( START DATE, END DATE, = specific day) and get an incorrect argument error.…
-
Invalid Argument with COUNTIFS formula
I have a form created to capture checklist Yes/No items for safety observations. There are several questions that are grouped by type (i.e. General, Electric, etc.). I have figured out how to use the COUNTIF formula to count the "No" answers for each group of questions to establish where the risks are taking place:…
-
0-30, 31-60, 61-90 Columns automated by formula (Checkbox)
I have a 3 column breakdown of 0-30, 31-60, 61-90 days and a want a formula to check the box between these based off the current dates listed for the task. What I currently have is =IF([End Date]@row < (Today@row + 31), [End Date]@row >= Today@row), 1, 0) but receive an error when doing so. How can i get this to…
-
IF Statement to check a box
I feel like this is so simple but for some reason, I just can't figure it out!! I have a smartsheet where we're ranking applicants. They can get a highest score of 60. I have a column named "Rank" that has a formula in it that breaks them into Rank "1", Rank "2" or Rank "3" dependent on their final score. When "1" is…
-
=COUNTIFS Function does not appear to work
Hi all, I am new to Smartsheets and would appreciate a little help. I have a sheet with a list of UAT defect reports within it and I am using a separate sheet to try to calculate various statistics. When trying to calculate how may defect reports are open for an individual I have used the following formula: =COUNTIFS({UAT…
-
Why is my formula not returning a 1 for blank Priority column?
I am trying to create a formula for two columns Priority and Director Priority. If Director Priority is populated, I want the cell to return a 3 if High, a 2 if Medium, or a 1 if Low. If Director Priority is blank, I want the cell to return Priority. If the cell is returning Priority, I want the cell to return a 3 if High,…
-
Join Collect - Return Multiple Values from a Multi-Select Column
Hi all, I have a change log where the "Assigned To" column has multiple assignees - I have another column where I would like to return the department(s) of the assignees, which is pulled from another sheet. However, when I use the following formula, it returns a blank result when I put two people in the "Assigned To"…