-
Calculating cumulative values and reducing the total sum each day
Hi, I have a Safety Violation Sheet that uses Form Entry to record violations and assign a measured Probation Period in days. If there are multiple entries for an individual, the probation days should accumulate, at the same time the value reduces by (1) for each day that passes without incident. I have (1) sheet that acts…
-
countif and contains statement for extended drop down menu
Hi all, I would like to reach out to the community to help me solve my (probably simple) issue I am facing. To provide you with some context: I am building an online database to enable tracking all the requested amendments and to gain inside into invoicing on a small scale. This database is created for different layers to…
-
How do you tell a cell what to do based on being a Parent or Children row?
I would like to use one formula in the entire column instead of having to copy and paste based on being a child or parent row. My child formula looks for word vacant in the name column and if so subtracts the total of 4 other cells from 0. If the word is not found the cell remains blank. =IF(CONTAINS("vacant", Name@row), 0…
-
Using COUNTIF together with a date range
Hello, I'm trying to count how many rows meet this criteria (use a cross sheet reference): Tier is Experiencia Lite (or whichever tier I need to count) and SLA was signed between 1/1/22 and 1/31/22 (will be doing this for each month) This is what I have but iI get an unparseable error: =COUNTIFS({Tier}@row,"Experiencia…
-
JOIN COLLECT FORMULA
IN PICTURE (A)- i have successful JOIN COLLECT formula IN PICTURE (B)- I tried to replicate the formula, but add additional columns I needed to be joined as well. IN PICTURE (B-1) Incorrrect Argument
-
Can you Index-Match referencing multiple sheets?
Hi! I am a newbie to Smartsheet and jumping in head first. I am trying to use Index-Match to bring in information to a master sheet, but I need the function to look at multiple reference sheets. Master Sheet Highlighted in pink are the columns I am referring to. I would like the User to manually input a number into the…
-
Report Filter - data from 2 sheets
Need help! I have a sheet that references data associated with a Week #. I need to filter this list for a report based on date. I created a 2nd sheet to simply show the dates associated with the week#. How can I in the report filter to show data for the week associated with the week# that starts in next 7 days? The sheet…
-
Using COUNTIFS with CONTAINS
I am trying to count the number of rows whose tier contain "Plus" and are within a specified date range. I have this formula which works for a specific tier (not using "contains"): This formula works: =COUNTIFS({Tier}, "Experiencia", {Original Launch Date}, AND(@cell >= DATE(2022, 12, 1), @cell <= DATE(2022, 12, 31))) This…
-
Mark Duplicate value
Hello team can someone suggest a simple way to mark cell (or rows) that one of the columns with Duplicate value thanks in advance oded
-
How do you exclude a specific status from another sheet in a formula?
Hello! I'm having trouble finding a way to exclude a status from this formula: =IF([Total on PTO]@row < 2, "Under Limit", IF([Total on PTO]@row = 2, "At Limit", "Over Limit")) It's referencing another sheet for PTO requests. The limit is including requests that have been withdrawn, but we don't count those as the actual…
