-
Calculating the duration between 4 dates
Does anyone know the formula to count the days between 4 dates. If the Ready to Launch date is greater than or equal to the Received IO, then the Duration would equal the number of days from Start to Launched. Otherwise, the Duration would equal (days from Start to Ready to Launch) + (days from Received IO to Launch).…
-
Index If?
Hi. I'm trying to retrieve a cell value from one sheet to another where it looks up the ID# and retrieves the Score. However, I want it to retrieve the most recent Score, because the sheet it is retrieving from is a historical record with many different scores assigned to that ID# over time. Could someone help me with the…
-
Formula help - trying to sum a column if launch date is in the next 30 days
Hello, I'm trying to sum numbers in a column a if the launch date is within the next 30 days. Thanks in advance for any help!
-
Using CHILDREN() to Define Range in VLOOKUP()
I have a parent row on Row 1 with three indented child rows. I want to populate a cell in the parent row with the first name from a child row that matches a value in one of the columns. There will be other parent rows with their own children, and the number of children may vary. Each parent row represents a "family", and…
-
Formula instead of cell linking?
Hi all, please note I've never used any functions like this so not sure if I'm asking in the right way. I have two sheets: Sheet 1 includes the following columns: - Project # - Start Date Sheet 2 includes the following columns: - Project # - Start Date (blank, needs to be filled with formula) How do I build a formula in…
-
How to keep a formula when a cell is modified
Hello, I have a bit of an odd situation and I'm hoping that someone might know how to help. We have a Smartsheet that we use when new clients come on board so that our Customer Care team can complete the account setup. The new clients are added to the Smartsheet via a form and we have formulas to automatically add "N/A" to…
-
Average formula with weekends excluded
Hello All, I need to tweak a very simple formula. Currently i have this '="Average Resolution Time - " + AVG([Time Taken to Complete]33:[Time Taken to Complete]148) + " Days" ' but i really need something that only averages workdays within that time period. Be very glad i any suggestions. I started experimenting with the…
-
Conditional Collect Formula
Hello, I am attempting to sum a range of numbers that meet multiple conditions. Data is input into my sheet with a time stamp and a box type(C1,CX etc.) I would like to sum the numbers that are of each unique box type AND are the first 10 timestamped inputs of the day. That is, sum the first 10 C1 inputs of the day, first…
-
Creating formula in smartsheet
Hello, I have a requirement to create the below formula in smartsheet. Please help. If short shelf life is between 40% to 59%, then discount is 5% on the invoiced amount, If short shelf life is between 30%– 39%, then discount is 15% on the invoiced amount, If short shelf life is between 20 – 29%, then discount is 40% on…
-
Any Potential for Linking Reports to Sheets?
Hello, I wish there was a way to link a report to a sheet - does anyone know how to do this, or is it possible? I am hitting my link capacities for our production reporting, but what I really wish I could do is to sum a qty in a report and then graph it on a dashboard. Is there anything in the works at Smartsheets…
