-
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)…
-
Move attachments between sheets
Is there any way to move attachments between sheets without the clunky "Move a Row" or "Copy a Row" automation?
-
Function() or @argument for "currently logged in user" for use in Sheet formulas
I would like there to be a function() or @argument (e.g., User() or @user, perhaps?) that I could use in Sheet formulas that would evaluate to the "currently logged in user". This would enable more flexible Filters in Sheets that could be supported by Helper columns for evaluating logic against multiple multi-select Person…
-
Adding date ranges to column headers
Hello Smartsheet Community, I saw something at the conference in November and I'm having a hard time remembering what it was called so that I can figure out how to use it, I think it was a "series". Here's my problem: I have several sheets that I am using to create "block based" schedules, each block is defined by dates,…