-
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)…
-
Update Report with new drop-down options
This is a multi-step question. I have a Client Data sheet. One of the columns is Household Name. I'd like to be able to report various metrics at the household level - as well as the individual person level of the Household. In the screenshot, you'll see the Household Name, the Owner First Name & Owner Last Name columns.…
-
Calendar View of Project Status Progression
I have been working with a colleague building out a Smartsheet to track the progress of 54 projects she’s working on. None of the projects are time dependent, but each moves through 5 phases during the course of its life-cycle. The name of each project and its status is contained within columns of the Smartsheet. Her…
-
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?
-
Adding YTD totals without using Sheet Summary fields
I have a sheet the tracks manufacturing operations. Each year, I need to summarize YTD totals from the sheet. This is resulting in many sheet summary fields each year. As time goes on, I will run out of the limit of 200 fields. Is there a way to automate any of this, either with automation or having information go to…
-
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…