-
Children function won't work past a certain rownumber
Hi, I am trying to use a sumif >>> =SUMIF(CHILDREN([Sales Stage]30); Status15; CHILDREN([Quotation budget]30)). However for some reason this function wont work passed row 40. Please help. Jesse
-
Using OR in a SUMIFS or COUNTIFS Function
Hi Guys, Smartsheet noobie here and I was wondering if it is possible to use a OR in SUMIFS or COUNTIFS function. Basically I want to sum a count values in a particular columns if either one of 2 criterias a met in another column. My basic syntax is along the lines of: Sum all the values in column A, if column B has value…
-
NESTED IF FORMULA WITH PARENT/CHILD ROWS
Hi everyone, I am struggling with a formula to populate a parent row, as either "On Track" or "Off Track". This is dependent on how the child row compares to the "Weekly Goal". The formula I am trying to use is shown below but, Im doing something wrong. (screen shot of sheet also attached) =(IF(CHILDREN([January (Week…
-
How can I display a date range based on week/month numbers?
Here's the situation: I have a bar chart on a dashboard that displays the dollar value of bids submitted by week going back the last five weeks and another for the last five months to help the estimating team track where we are on meeting goals. At the moment the labels under the bars are Last Week, 2 Weeks Ago, etc.…
-
Summarizing and aggregating for the same code from multiple sheets
Dear Expert, I have 40 sheets containing following column with example (example for one sheet only): Equipment ID | Equipment Group | Part Name | Quantity | Unit Price | Total Price 11MBX21 | AAF | Bearing | 2 | 150 | 300 11MBX22 | AAF | O-ring | 1 | 50 | 50 11MAK10 | BAC | Sensor | 2 | 500 | 1000 11MAD15 | BBA | Switch |…
-
form data capture
I am collecting daily sales totals and transaction totals with a form. The store manage enters the totals into a SS form daily and it populates the SS. I would like the entries to sub total into months as they are added to the SS... then those monthly totals can roll up onto a dashboard, along with other department…
-
Formula needed that will generate quantity in one column against date in another column = how much a
I have the following columns and need to return the value of something from a date through the end of the year. 1. Est Mo Contract Count - A number 2. Ave admin - Dollar Amount 3. Estimated Value - 1 x 2 4. Start Date - Start Date that 1 actually goes into effect 5. Weighted Value - Sum of 4 through end of the current year…
-
Smartsheet Dashboards vs Live Data Connector Integrations
Hi everyone, Has anyone used the live data connector to integrate with another platform such as Qlik or any other? I know that SM now has the dashboard view, but I do not think it is as powerful as other BI platforms. From what I see, the SM dashboard is a very high level overview and does not give the level of detail that…
-
Extracting all instances of a word from a text string and creating a list in a separate cell
Hello all, I have been pouring through excel and smartsheet help forums for a couple of days now, and I haven't seen my issue asked or addressed so thought I'd ask here. I have, in one column called Terms, cells that contains lists of terms and phrases. For example, one cell contains the following text string:…
-
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!
