-
Reference a sheet and count the number of a specific health icon based on status.
Hello, I am referencing a project schedule in a sheet where I am counting the total number of rows that have a specific health icon color. Green, Yellow, and Red were all straightforward to get totals for. My formula for those is: =COUNTIF({Project Schedule - Health Column}, [Health Icon]4) for each different health icon.…
-
Average If with three conditions
Hi there, I have the average if function working correctly with condition but my formula falls apart when I add the other conditions. This works: =AVERAGEIF({Other Sheet Range 1}, Property@row, {Other Sheet Range 2}) Range 1 is just the property column and range 2 is just the data to average. This doesn't work:…
-
Consecutive Issue Formula
Hello, I am trying to figure out if there is a formula that will count the number of entries that have occurred since a different entry was input. In this scenario, Yes and No are the only inputs. The Yes and No correlate to whether an item is working properly or not. So the formula I need would populate with the number of…
-
Pivot App Max Rows & Columns
Hello, I am trying to configure a pivot table and am getting a message stating there is a maximum number of rows of 4 and columns of 1. I called support and they don't seem to know why I'm seeing what I'm seeing. Has anyone else seen this? Thank you, Khari
-
Notify an assignee that the predecessor has complete his task.
I want to use smartsheet as an international project management tool. One thing is driving me creasy. I want to send out a notification to an assignee if the predecessor task is completed. Please find attached a screenshot of my scenario. The task in row 27 needs row 25 & 26 to be done ( active checkbox in column "done").…
-
Countif & Contains
From what I can tell this formula should work, but it's returning a 1 when it should be returning a 2 =countif([Bakery - Emp Health, hygiene, supervision, knowled]@row,contains("C -",@cell) Help?
-
Returning value based on date in another column
Looking for a solution / formula type on the following: I want the Actual Phase Number column to give a number between 1 and 8. The number it will give is calculated by first looking at the Actual DOC column. The date in row 1 showing 12/13/22 will look at Scheduled DOC and find the most recent date before. In this case,…
-
Can Smartsheet Count Dates?
I have tasks in each month and want to count those tasks within each month in my metrics section. Here's my formula to calculate February tasks: =COUNTIFS([End Date]:[End Date], ">=02/1/19", [End Date]:[End Date], "<=02/28/19") In Excel this works, in Smartsheet I get a 0, but have tasks within those dates. Help!?!
-
Create column with unique values from another column
I am working on creating a sheet to be used for reporting. I have pulled in the contact list of names using the cell linking feature however, there are multiple rows with the same person. I would like to create a column listing just unique people. I started by creating a duplicate checkbox column using the formula:…
-
How to show last passed child on parent row?
I have been trying different ways to show last passed "gate" of a project. The project can have from none to few child rows. There is a column with passed gates as tick marks. Now I want to show the last passed gate text side by the parent row. I haven't figured out how to do this automatically. Any help is welcome!