- 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.…
- Formula to count of items in a multi dropdown list
Hi The drop-down multi select is very nice and useful. I started to use it yesterday, but I need to use the formula =countif(range, criterion). I want to count how many times a value is repeated in a range that has multi values. I use the formula countif and only count one time a repeated value when the cell have multiple…
- Complex JOIN(COLLECT())
Hello all, I'm hoping to use a formula to return a JOINED list of shared USERS for all sheets in Sheet 1. I have three additional sheets that contain all the supporting data, but since I don't want group names, is it possible to perform the user lookups from the groups sheet within the COLLECT function? Sheet 1: A list of…
- Formula to generate date 1 year from today?
I am trying to figure out a formula that will generate a date that is 1 year from today. For example, if we have a contract that requires 12 months of notice to cancel, and I have a column to track the Earliest Possible Termination Date, I want that column to tell me the date that is 1 year out, or 365 days after today.
- 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…
- 公式显示多选选项separately
I want to use the same formula, but instead of adding number amounts, I want it to display multiple selections in another column. Currently, tried this: =IF(CONTAINS("- Joining neighborhood-based, in-person adult learning house parties", [22/23: Torah (Learning) Commitment]@row), "Jewish Journey") + IF(CONTAINS("-…
- 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
