-
Help for Status Change and Tracking
I am trying to create dashboard widgets from data that I am tracking. For this widget I am wanting to have a graph show the number of people in each status section I have listed: "Not Started", "In Progress" and "Completed". Each employee has an individual sheet with tasks listed along with corresponding start/end dates,…
-
Countifs statements for date fields that are in the past
Hi there, I am looking to summarize data from a master sheet for inclusion into a dashboard via a project metrics sheet. Within the master sheet I have an “Opening Date” that is populated when the opening date is decided. I want to populate the Dashboard with the number of sites that HAVE opened each month (past tense).…
-
Need help with pulling contacts from another sheet
Hi. I have three different agencies that have a list of employee names and email addresses. When I do data entry into Smartsheets, I am trying to pull the list of the agencies email addresses into the form so I can send them an email. Here's the formula I have so far, but I'm getting an #incorrect arguement set.…
-
Combine all row comments in one cell in same row?
I am needing to create a cell that has all of the comments for a particular row combined. We need to display more than just the latest comment. I understand that there is a 4000 character limit for a cell. It would be nice if it showed the latest 4000 characters or we can add a second row/ cell for overflow. I found a post…
-
How to count the latest status on a record
Hello! I have a sheet that's feeding on an automation from another sheet and it is set to copy a row whenever a status changes on a case. Now I'm working on a series of monthly dashboards and I want to show the count of cases that where in each one of the status before each month ended. This is my sheet that's feeding from…
-
Formula to auto-summarise Delivery Risk assessment
Hi all, I'm attempting to build a function into my master milestone tracking sheet which will auto-populate my ‘Delivery Risk’ column, based on a series of conditions met in other cells in the row. Underpinning thinking is as follows: ‘Target Milestone Date’ are set for every row Assumption that ‘Actual Completion Date’…
-
I need to have a count down from Column A Date with the current date and show the number in a column
Colum A Date - has a date ( if in the future ) Colum B - should show me the countdown as per the current date
-
Counting people
Hi Smartsheet Community I use smartsheet to manage volunteer opportunities for my organization. One sheet details the employee, event, date, etc. for the whole year. I want to find out how many total employees volunteer without having to go through the entire list and cross out duplicates. Any tips on how to do that? thank…
-
Index/Match Formula - No Match to show Blank
I've been skimming the community here to try and find the IFERROR formula to add to my formula below so that if there is no match, a blank cell populates instead of #NO MATCH. The end goal is to populate a blank row so that users can put the right details into this cell from their reports. NO MATCH doesn't allow this.…
-
COLLECTMOD() formula
=COLLECTMOD([Return Range],"Modify Return Range",[Range 1],"Modify Range 1", "Range 1 Criteria", ...) Leave blank if there is no modification to the range.
