-
COUNTIF with multi select dropdown
I'm having trouble with the multi select dropdown option. I have a sheet with the data/responses. I'm creating another reference sheet trying to count the responses. So example, here's my test data. There are multiple options for fruit. In a difference sheet, I'm trying to count the total responses. So Grapes should be…
-
Calculating Number of Tasks above 50%
I am trying to calculate the number of tasks I have in a sheet, which are currently sitting above 50%... this is for dashboard purposes so we can see how many tasks are in the final-closing out stages etc. My formula is not returning any count whether I try it in sheet summary or a separate sheet.... any clues? Result in…
-
Linking two sheets into one master sheet
Ok Here is what I got, I have two employees who work for purchase import section. From Rising the IPO to having the LC created to have the goods delivered to the factory. I have created a common grid header for each of them and they are populating it as I write this. I will then create a master sheet where I will put in…
-
Copy Row Automation - Eliminating Duplicates OR keeping latest Row entry/update
Hello fellow Smartsheeters, I am trying to capture entries from a project level RAID log and pushing them (based on specific criteria) to an Enterprise level RAID log. Specifically, any Risks or Issues that are created and updated need to be pushed to another sheet. I am familiar and frequently use the Copy Row Automation…
-
Calculating how long a query has been worked on and how long it remains at particular statues for
Relating to this previous community query, I've got 2x similar queries.. I've posted it in that conversation but wasn't sure if it bumped it up the queue, so thought I'd post a new thread just in case it wasn't. I've used the formula @Paul Newcome provided in his post to tell me how long since the creation date the…
-
Merged: Easily create recurring tasks
This discussion has been merged.
-
tracking # of employees quarter over quarter
I'm trying to show on a graph how many employees we had in each quarter. How would I do that? My initial idea is to add a helper column for each quarter, and add a formula to return a 1 if any of the date range of that quarter falls after their start date and before their end date, then pull a report counting the 1s for…
-
Crosstab style reporting from Gantt data
Looking for some help on Crosstab style reporting from Shartsheet Gantt data. I have a Gantt project like the below ... How can I produce a report like this one I mocked up in an Excel Pivot table after cutting and pasting and "massaging" the Gantt data? ... Do I need the premium Pivot App (which we don't have) or is there…
-
Consolidating Parent/Children Rows in Reports
Good Afternoon - I've recently been assigned the Ops Planning Project from another PM mid-way through the process. We have 6 company objectives that each of our 13 department's objectives must roll up under. Each department has completed a Smartsheet with their individual ops plan using the following hierarchy: Parent Row…
-
Unable to extract sheetId from row object in a Report
Hello! I would like to create a pandas dataframe with smartsheet Report data. # Method to convert report to dataframe col_names = ['sheet_id','row_id'] + [col.title for col in report.columns] rows = [] for row in report.rows: # Append the id first cells = [] cells.append(row.sheetId) # This is where I get an error!…
