-
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.
-
CountIFS contact is in a contact list
=COUNTIFS({TEST Range 1}, ="*Name*", {TEST Range 6}, ="DO") Hi all, this is a helper sheet used to get the counts of different conditions. Test Range 1 is a contact list that can contain multiple contacts, how can i make it so that i can check if "Name" is in the list. It is currently returning 0 when it should be finding…
-
Column to Column: Activating set values in a column
Hello, I am trying to develop an inventory sheet for thousands of products. I have everything categorized under (8) main categories. Is it possible to have specific set of subcategories to populate in the next column (as a drop down option) depending on the parent category? I am trying to limit the number of options in the…
-
Invalid column value when both columns are text
hello! So this formula worked for a second and then for some reason stopped when i changed the return text from its original 'test' to 'half' . But it's still working on the column to return dates its just the text/number rows not working. The reference and return columns are all text/numbers. I am trying to reference a…