-
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…
-
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)…
-
Including attachments in message only automations
I have created a message only automation (cannot include the link to the smartsheet) to be sent when a new row is added via a form. The form includes an upload of a document; however, when using a message only format for the automated email I am unable to include the attachments. Any help is appreciated!!
-
Reusing a formula, but it's not working. I need to calculate deviation on End date.
=IFERROR(IF([End Date (Projected/Actual)]@row = [Target End Date]@row , 0, IF([End Date (Projected/Actual)]@row > [Target End Date]@row , NETWORKDAYS([End Date (Projected/Actual)]@row , [Target End Date]@row ) + 1, IF([End Date (Projected/Actual)]@row < [Target End Date]@row , NETWORKDAYS([End Date (Projected/Actual)]@row…