-
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…
-
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…
-
autopopulate the percentage complete based purely on the time passed
My goal is to have the percentage update automatically each day. If the task has a duration of 45 days and we are 3 days in, I need it to show the percentage complete. It would cap at 100% once it has reached the end date
-
I created a date column to generates dates by adding few fields but I am getting an invalidoperation
my formula is returning number of dates, as in adding dates.