-
Sheet Summary COUNTIF error when summarising formula driven cells.
Hi all, I'm creating a sheet summary report with the intention of summarising when passed tasks were completed relative to planned completion data i.e. early, on time, late. To do this, I'm using an =IF formula (which works) to define how to label tasks in my "Completion" column based on whether the 'Actual Completion…
-
Multiple Checkbox's for sheet summary into a dashboard.
Good afternoon, I am looking to see if this is possible. I am looking to have a dashboard automatically populate with a new row when another is "complete". Which I am able to accomplish with automation tasks. The issue is building the dashboard that has multiple columns of checkbox's. Please see the photos below for an…
-
Formular: Only two requests each department per week
Hi Community, I have a sheet request form that capture transport requests from each department. Heres my scenerio: For my organsiation a request for transport is allowed only 2 request per week for each department. Requests more than two is automatically cancelled for the department. what formula can I use to a helper…
-
Smartsheet CountIFs
I have 2 SmartSheets. The first one (Sheet1) has customer data with some transactional information ('Customer Number', 'Order Number', 'Order Number', 'Licenses Used', etc.). The second one (Sheet2) has all transactional information ('Customer Number', 'Part Number', "Serial Number', 'Entitlement Complete (Y/N)', etc.).…
-
Is there a way to reference a summary field from one sheet in another sheet?
I have sheet that contains master data for customers. The master data customer sheet has a set number of support hours available for each customer. I have another sheet that is collecting support hour information for the customers. A summary field has been created for each customer that sums the support hours for that…
-
Moving Sheet Summary Fields
Currently to rearrange the fields in the sheet summary you have to open the field properties and then move it up or down one at a time. If you have a good handful of fields and then realize that the three or four at the bottom should actually be at the top... That gets to be rather tedious. Would would be great is if we…
-
SmartSheetAPI PUT
Hello, I want to use the Smartsheet API to update the content of a cell. I have set the API key in the header and tried the following using Postman: PUT Request URL: https://api.smartsheet.com/2.0/sheets/{sheetId}/rows/{rowId}/cells/{columnId} Request Body (JSON): { "value": "test", "displayValue": "test" } However, I'm…
-
How to I calculate percentage progress in sheet summary based on status?
How to I calculate percentage progress in sheet summary based on status?
-
simple COUNTIF Sheet Summery formula
need help with this simple formula for a sheet summary =COUNTIF([IEP Status], "NEW (not signed)", "Active", "Active (Needs Att.)") something is wrong with the formatting I want to count number rows that contain these specific drop down list values. I put the values in quotes but the parentheses from the drop down values…
-
Email automation with PARENT/CHILD data from pivot table
I'm trying to create an output of specific rows of a pivot table to attach/include in an automated email. See below for an example table I'd like to extract from the master pivot table. The "Alert someone" automation allows me to specify which cell information I want to include but does not seem to be able to allow for…
