-
Multi-part calculation
Hello. I have an "intake" sheet in which I now have a calculation sheet in order to start putting numbers on a dashboard. What I'm trying to do: Set up a formula where Smartsheet will (for example) sum the Units sold only if the Year is 2026, month is 1 and City is New York. Smartsheet has been hitting me with a "0" when I…
-
Risk Register Set Up
Hi, just need some help with formulars on a risk register (I have set up the form and associated grid): Equation for Risk Level with the following breakdown Very Low - light green Low - green Medium - yellow High - orange Very High - red Extreme - dark red Thank you :)
-
Formula for 2 values, whichever is larger
I am needing a formula for "[2026 Media Plan]*.05" OR "5,000" whichever is larger. I know it's an OR statement, I just can't quite get there. Thank you!
-
Formula to bring dependent values
Hello Experts, I need to return a formula with Yes or No based on a sequence of current status and the preceding steps needs to be covered. The sequence is applicable as below. Pending Dependencies (F) Not Started (F) Pre Set Up (F) Set Up (F) Smoke Test (F) Smoke Test Validation (F) Full Run (F) Full Run Validation (F)…
-
Counting Results from a Index Match returning #No Match
I am trying to count the number of cells that return "Done". I've used =Countif([Status]:[Status],"Done"). The column is populated by an index match formula and I am getting a #No Match result . What do I need to change?
-
01/01/70 View Activity Log Issue
Hi all, I see more and more issues in multiple of my sheets using date. The issue is for every data column including created date and just date. This results in data not coming through properly in aggregations, indexmatches with date in it, column formulas etc. Is anyone else experiencing the same issue and how could this…
-
How to calculate % Planned in Father Rows?
Hi Community I created a new column to calculate the planned percentage in my project; however, in the father rows is not calculating correctly, even if I tied the percentage between complete and Planned, the percentage is not the same. I am using the following formula =IFERROR(IF(Finalizar@row = Inicio@row , IF(TODAY() >=…
-
Multiple IF condition is not working
I want to apply a formula so that when a value is greater then 9, it should mark the initiative as high priority, 6-9 be marked as medium priority and less then 6 is low priority. The most letest formula i wrote is: =IF([Priority Score Final]@row > 9,"high",IF([Priority Score Final]@row >6,"medium",IF([Priority Score…
-
Flag first occurrence as “Unique” and others as “Duplicate” by person + date
Hi Community, I’m working in a sheet with a bunch of historical data that has these key columns: [Personnel Name] (staff contacts) Date (date) [Duplicate Check] (text, where I want the formula to live) What I’d like to do is: Treat each combination of [Personnel Name] + Date as a group. For each person+date group, mark…
-
Managing dates
Hi SS Community! I have a feeling this maybe a simple answer, but I have looked on the internet with no resolve: I have "Project Plans" for each one of my projects. I use dependency settings. For dates I have Start Date, Due Date, ESTIMATED NUMBER OF DAYS TO COMPLETE, Estimated Completion Date and Complete Date (Record)…