-
Formula to Capture Total Days Open with Status Changes
I hope that everyone is well! :) I have a use case where I need a formula that allows me to capture the number of days a request has been open but stopping and starting the clock when the status changes. From: In Progress to On Hold to In Progress to Closed. Also, I would only like to count weekdays. (No weekends or…
-
INVALID OPERATION ERROR - HELP NEEDED
Thank you in advance for your help. I actually worked with Smaartsheet's AI Help to generate and work through the formula. I have checked it twice and still get the same error message. Here is the formula: =IF(AND([Tester ID]@row = {DE2ET Tester ID}, [Scenario ID]@row = {DE2ET Scenario ID},…
-
"metrics sheet" - showing First Day of Week from Week Number
For additional context, I am building on what I outlined here. Short version is that I have a sheet that is pulling in aggregated data to show changes over time. I would like to show the first day of the week as well as the Week Number and have tried adding a column with this formula: =DATE(2025, 8, 25) + (([Week…
-
Help with INDEX/DISTINCT Not Working!!
I have the following formula: =IFERROR(IF(Auto@row = 0, "COMPANY NAME", INDEX(DISTINCT({Company Name}), [Row ID]@row )), "") Problem is - it has stopped working. It pulled out the first 115 vendors out of 425 items, and then stopped. Is there a maximum number of distinct items it will pull into a list? I do not see any…
-
Copy Parent Issue Key (link) into Child Row as a link
Hello! I am trying to pull the issue key link from my parent row into the child row. I have used the formula =PARENT([Issue Key]@row ) But it returns the text only, not a clickable link. Any ideas?
-
Attachments to In-Cell Images
I cannot figure out how to automate the process of moving cells to images. I've read this can be done through power-automate, but frankly coding is out of my expertise. Is there a simpler way to do this? These attachments are added through form entries.
-
Multiple Forms - Add info to existing row
Hello! We work with a registration form that feeds a master sheet, we want to add another form that will update or add a request for change for a registered contact, but we do not want to generate a new row, we want Smartsheet to match the name or ID to the initial registration and update the columns. Do we need a formula…
-
Auto sequential numbering even after moving rows
Hi everyone, I am looking to have a auto sequential number column that keeps sequential numbers even after moving the rows. For example before moving the rows: After moving the first row to the bottom, I would like to have the numbers to still be sequentially ordered in the Auto Number column: I have looked at solutions…
-
Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
-
New to formulas: auto creation of + or - 4 week visit windows
Hi, I am new to formulas. If I have the initial visit date in one column, I'm wondering if there is a way to have actual dates inserted in preceding columns based on the initial visit date: 1 column showing the next possible visit date +X week or days date max and then in another column the -X week or days date min. Is…