-
Count the number of times multiple values appear in a column
Hello SS Community, I'm trying to count the number of instances two values appear together in a cell. From the following example, I would like to count how often "Contractor" and "Vendor" appear together, and furthermore I would like to sum the budget for those instances as well. When I use the CountIf with Contains…
-
COUNTIFS error when finite rows not set
I have a formula that calculates the week number, and counts all items with the priority of 'Standard' within that week. The issue is that my 'Creation Date' column currently has 97 rows, but this will increase. The formula below works, but not if I remove the row numbers. I haven't seen this behavior before, did I set…
-
IF statement to update a column when box is checked!
Hi, I would like to update the 'Status' Column to CLOSED when the 'Done' checkbox is CHECKED.
-
At Risk Flag Formula issues/questions
I searched through the Community and found a couple of formulae that either directly addressed what I want to accomplish or I thought could be modifed to do what I want. I get the #UNPARSEABLE error for each of them. I'm sure I'm missing something basic (new user) since all of the responses to the solutions are positive. I…
-
RYG Balls Need a Little Help Please
I have contacted the help desk and they suggested for me to post a question on the forum.... 1. Get help with RYG Balls.... If start date is a date with no due date and at any % completed then yellow... If due date is 3 days in the future then Yellow.... If due date is today Red...... if due date is tomorrow yellow .....…
-
ABSOLUTE CELL LINKING
Im really struggling with getting an absolute cell value to stay in a sheet or in a sheet summary. maybe im going at in the wrong direction. please help. I have a form on my call centre data sheet that is adding an information line each day. The line is picking up all my formulas for my metrics on who is answering the…
-
At Risk Formula Update
Currently using the Onboarding Template Set and in the Sheet Onboarding timeline, I have the Risk flag set, the current formula is to flag if the end date is in the past and the status is not compete (for the row)formula is =IF(AND([End Date]9 < TODAY(), NOT(Status9 = "Complete")), 1, 0) but I need to update it because I…
-
Formula to record attendance using check boxes and flag the row if missing meetings?
I am new to SmartSheet and need assistance creating a formula or function to make it easier to to keep up with attendance for meetings once a month. Any one person from the group can attend and as long as one person does, the entire group gets credit. I would like to use a function which will give me a quick indicator that…
-
Sum Children formula
Hi all. I am having an issue with getting a correct sum from children of a parent row when using a formula in the children rows. Ex: Children row formula is =IF([Date Completed]43 > [Due Date]43, "1", "0") There are two children rows; the formula above creates a 1 and a 0 respectively, however, my =SUM(CHILDREN()) formula…
-
Counting open tickets based on company name and ticket status
Hi, I'm trying to count the number of open tickets by company name, and the cells I'm referencing are in another sheet. Here's my formula so far: =IF({Maintenance tracking Sheet Range 2} = [Company Name]@row, COUNTIF({Maintenance tracking Sheet Range 3}, {Maintenance tracking Sheet Range 3} = "Open")) But I'm getting an…