-
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…
-
Allow Gantt view to use Date columns with Column Formulas for Start/End
I'm kind of flabbergasted that this is not currently possible in a Sheet, and I'm struggling to explain to my users why. It is already possible to populate a Date column with a Column Formula and then convert it to a Cell Formula, and then use that column as the Start/End for Gantt view / Project Settings, so the issue is…
-
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?
-
AI Tool for Business plan users
Will the AI Tool be made available in some form for Business plan users at some point? This would really benefit me creating formulas, I've always struggled with them! 😣 Please consider!
-
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…
-
Countif formuls
I'm trying to have a countif formula for a column that will count only if the space contains 100%, I can't seem to make it work, this is the formula I tried: =COUNTIF([FAT Completed]1:[FAT Completed]90, ="100%") anyone have any ideas
-
COUNTIF problem
Disregard. The problem was additional dates on collapsed child rows. Thank you. Good afternoon. I have created a metric sheet that was then used to create a chart. The formula is written as: =COUNTIF({Date of Visit}, IFERROR(YEAR(@cell ), 0) = Year@row ) This was then drug down for 4 rows. Rows 1, 2, and 4 have the correct…