-
Help with a Simple Formula
I am trying to calculate a formula that I can use in a dashboard graph. I need to show the following: status of a task (i.e. completed, in progress, etc) That it is US only (management responsibility) The end date is within the year 2026 This is what has been generated for me, through SS AI - COUNTIFS({My Sheet Name here…
-
Getting error in a countif formula
Hi all, I am trying to expand on my regular countif formula but I am getting an error. The original formula: =IF(Order@row = 2, SUMIFS({Costs}, {Date}, Date@row, {Location}, location@row), SUM(CHILDREN())) works perfectly fine. However, when I add onto this formula, I get an error: =IF(Order@row = 2, SUMIFS({Costs},…
-
INDEX/MATCH formula error, "No match" when there is an exact match
Hello! I'm using an INDEX/MATCH formula to return the "Type" associated with a specific "Email." I'm getting a no match error when an Email value is first repeated. After the first repeat, the formula no longer functions. I've included my actual and desired outputs below. Both the form submissions data and the summary data…
-
Modified SUCCESSORS() function to report more than just direct successors
WHY IS THIS USEFUL? This updated function would allow us to filter the spreadsheet for only the driving path to a particular row#. This would be similar to a filter for critical path, but enable much more flexibility. Current status: I've successfully generated a "Successors" column, listing direct successors of each row,…
-
Is it possible to reference a cell or summary field in a column formula?
At the top of our templates we have a Summary section where project (deliverable) details and key people are specified. I am wanting to reference the 'Deliverable Sponsor' cell within a hidden column on the sheet so we can create reports pulling through all row data across all deliverables that belong to that Sponsor. From…
-
Formula on Target Date Column
Hi, I am trying to create a formula in Smartsheet that automatically calculates the target date for a task based on the “Go Live Date” and a “Weeks Prior” value. For example: Go Live Date column has 08/02/2026 Weeks Prior column has 12 I want the Target Date column to automatically calculate the date that is 12 weeks…
-
Need a cell value on each row
I need a way to either do a checkbox or a value for each row in my sheet if a cell has a value. I can't use = [Column name}$6 because the column formula does not support this. Does anyone know a work around for this?
-
MIN & MAX Collect Formula Help
I am trying to write a cross sheet formula that evaluates dates based on a matching project ID on the source sheet and return a date value in the target sheet (where the formula is being written). The formula should: Look up dates in a column on another (source) sheet. Each row on this sheet has a unique ID. Only evaluate…
-
SUMIF OR SUMIFS
I hope I can explain this correctly. I have three separate columns I am working with. My goal is to sum the total footage of certain rows that have been approved within the last 7 days. My columns are: FOOTAGE, STATUS, and DATE APPROVED. I would like to have a total in a separate cell at the top of the sheet. I keep…
-
Replacing all special characters in form query string parameters with a formula
Hello everyone! I am excited to be speaking at the "Leveraging the Query String in Forms" session at Engage 23! I wanted to share a formula that a customer and I developed to replace any special characters that could show up in cell when you are building a URL to a form with query string parameters using a formula. This…