-
COUNTIF is double counting rows with multiple assigned contacts
Hello all, I am trying to count rows for one department. This department also has sub-departments. In some rows, it has multiple sub-departments assigned to it. This is my formula: =COUNTIFS({Requests Range 2 - Status}, Category2, {Requests Range 4 - Department}, (FIND("Merchandising", @cell) > 0)) For example, one row has…
-
Gantt zoom to current day (centered) on open?
Hello, Is there a setting to set the current day to be centered in the gantt view when I open my sheet? I always have to scroll over to the current day on long projects. Thanks, Phil
-
SUMIF Formula question
Hello, I am attempting to create a formula that calculates the sum of the Actual Savings column, if the non-applicable column is not checked. The formula I am using is =SUMIF(CHILDREN([Non DH Applicable?]@row), 1 + ""). Not sure why it isn't calculating correctly.
-
Standard Milestone Names
I am creating a project template for my department to use for all projects. I have created drop menus to limit certain column entries to a controlled list of choices. I would like to do something similar to control how the user names a milestone. Is there a way to have a list of standard milestone names for the user to…
-
Formula Help: Completed Project Count for Parent Rows Only
Hello, I am new to SmartSheet, and I am trying to create a formula that adds up the total number of projects that have a check mark in a Completed column. Note: I created a row to star all of the projects in parent rows (to distinguish from tasks in the children rows). So essentially, I want to add up all of the starred…
-
Formula return blank result
I've attempted multiple times to create a function that result in Blue, Yellow, Green, Red health and it has been unsuccessful. Here are the results that I am aiming at: On Track > "Complete" "In Progress" = Green Ahead > "Complete" = Green Ahead > "In Progress" = Blue At Risk > "Not Started" "In Progress" = Red Behind >…
-
Cross-Sheet Reference Limit
Concerning the current limit of 25,000 total cross-sheet references per sheet - is there an easy way to determine how many are currently being used on any given sheet? Thanks!
-
How to create report with rows instead of columns?
Why does Smartsheet only allow you to make a report with columns and not rows? I'm using my sheet to coordinate data for events. Each row has a specific event, each column has different details for the events (date, location, hotel, meals, etc) and I need to take information from only certain rows to create a report for…
-
HOW TO REMOVE #DIVIDE BY ZERO AND MAKE CELL BLANK
I am trying to average a customer feedback section of my sheet. But if the cells where the data to be averaged will come from, the result section shows #Divide by Zero. I use the formula =AVG([column1:column2]). What's the formula I need to use for this? I saw in the other community discussion that I can use IFERROR but I…
-
Send a link to a report to users that have tasks due that day
I'm not sure what the best work flow is for this but here is my current setup: * I have a task list with all tasks for the duration of a project. * I have reports that list all tasks due within the next day or week for the "current user" * Currently users get alerts for every task that is due on that day (multiple alerts /…