-
COUNTM Formula Help
Is there a way to use the COUNTM formula to count the number of selected dropdown options in a multi-select column (e.g., "Deposit Accounts") only when another column (e.g., "Region") equals a specific value (e.g., "East")? For example, I want to count how many Deposit Accounts have been selected only for rows where the…
-
Can't get the "Ongoing" piece to work
I'm trying to make a formula, a typical status formula which I do often. But it was asked to include an "Ongoing" status when the % Complete column is at 99%, regardless of other conditions. The problem I'm running into is that no matter how I input it, the "In Progress" piece always overrides it, and I can't quite get the…
-
Identifying data associated with a previous row
Thanks in advance! From a listing of all meetings, I am hoping to pull in the date of the previous meeting. Note, there are no successors/predecessors with this (I've been able to successfully use Paul's post in other areas to pull in the task name and hoping somehow this could be similar?) Has anyone done anything…
-
Adding two or more cells in the same column according to date
Hello, I have multiple cells in one column, which are numbers, with the same date and I would like to combine the figures into one cell, with the date in an adjacent column. Combine the two Manpower Daily entries for 19/5/25 into one entry in the Project Manpower column. I've tried a few formulas and nothing seems to work.…
-
Help with averaging a column with blanks
trying to average a column that will ultimately be used for a report however I am getting the #DIVIDEBYZERO error and the community notes haven't helped. I was able to write a formula to leave all zero values blank, now I am trying to average the column… little help please. =AVG([Cost/Mile Customer]:[Cost/Mile Customer)
-
How to conditionally format a row to show changes within the last 22 hours
Hi all, I am trying to come up with a way to highlight an entire row after a change has been made within the last 22 hours (not a full day). I have a sheet that is reviewed and updated in a daily meeting, but want to set the stage for the next meeting by only highlighting rows that have changed since that meeting. I have…
-
Date & Timestamp a specific cell change
Hello, I am very new to Smartsheet and I am working on a project tracking sheet. We have the following statuses in a cell: Unassigned; In Progress; Completed; Cancelled; On Hold When a request is submitted this automatically triggers a 'Created Date' column that logs the date/time of creation. I would like this to be…
-
Formula Help! Adding Values in child rows based on date range
I'm trying to add the values entered in all child rows in a column, based on the date range (by quarter): =SUMIFS(CHILDREN([PT Total Hours]@row ), CHILDREN(Date@row ), ">=01/01/2025", CHILDREN(Date@row ), "<=03/31/2025") This is what the AI formula came back with, also what another external AI platform came back with.…
-
If a cell contains three specific values, assign a numerical number
Hello community, I'm relatively new to Smartsheet and need some help with a formula. I am trying to have a number appear in a helper column when three specific options from a multi-select drop down list are selected in the same cell. I have included a screenshot of an example of what I am trying to do. If Option 1, Option…
-
Index between a group of dates to return a corresponding row value
I need to add a formula with the "period end date" to have it automatically update to return the "period rate year" that it falls within - e.g., 1/31/25 falls within 4/1/24 and 6/30/25 so it returns 2024 in the yellow.