-
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…
-
Latest Score Given
I am trying to return a score based on the date and contact. what I am looking to do is search my list of names and show what the last score each person was given. I can easily come up with the last date a score was given but I am stuck on how to get the score that is related to that person and date.
-
how to define who the approval is from multiples
I have migrated our Engineering change to smartsheets which is working fine. I now want to progress this by adding approval requests. We can get changes approved by 3 different people, so I have created an approval request which gets sent out once a box is checked to declare the change is ready for approval. At present…
-
Finding preceding dates
I've created a productivity dashboard for myself and need to find a formula that returns the previous months so I can reference them in a COUNTIFS statement. I have a formula which works fine BUT it doesn't cope when the date crosses a year boundary, ie if the month is September (month 8) my formula will get August's stats…
