-
How do I use the attachment column in a Sheet Summary Formula?
I want to write a sheet summary formula that counts how many rows where the MoSCow column contains M, have attachments. The syntax I am using is COUNTIFS( range1, criterion1, [ range2,criterion2]). I have used this formula many times Getting the column criteria (range 1, criterion 1)specified is straight forward. But I…
-
Formula for "Days since" event
Hi There, I'm looking for some help with a formula for a sheet summary field. I'd like the field to display the number of days since "today" that a checkbox was checked, based off the date entered in that checkbox's row. Example based off screenshot: "Today" is 12/4/2023. If the checkbox for Row 66 is checked the "Days…
-
Report Grouping Issue
I have report that summarized about 38 sheets using sheet summary fields. For some reasons, one of the fields isn't coming through so the report is not grouping properly. It's only happening for a few sheets but it's the third time it's happened this week. To fix it I have to go in to each sheet summary, take a letter off,…
-
Converting Sheet Summary Metrics to be used on Dashboard
Hola! What's the best way to convert sheet summary metrics into data that can be visualized on a dashboard? Muchas gracias in advance.
-
Viewing team capacity over time
I am trying to see my team's capacity over multiple projects for each week to see who will have capacity to take on new projects. In the past I've done it by hand to look like this and I know in my mind the demands of each phase for a given project. This is quickly becoming unsustainable as we grow. I have a task list for…
-
Using Sheet Summary To Populate Columns - and Have Same Restrictions
I'm using a sheet summary to add some global sheet data (i.e., it's not associated with rows, it's associated at sheet level.) I've got a sheet summary contact list field where I add the project manager - then it populates the top cell in a column. I then use this cell as an email recipient in a workflow. However, it…
-
auto lock Summary Fields
Hi I'd like a way through automation to be able to lock summary fields based on criteria in a sheet cell, or another summary fields. I use Summary fields as a switch to do actions in sheet. for example I allow PMs baseline effort and costs through changing a summary field trigger to yes, but after they have done that I…
-
Sheet loading issues - taking too much time to load the sheet
Hi, I have a order intake sheet where I refer the stock quantity from Item master sheet and grant amount from Grant master sheet. I'm doing most of the calculations(like quantity check and cost check) in the order intake sheet. in the particular sheet I have nearly 16 formula columns and multiple sheet referencing due to…
-
Using Get Report activity in UiPath throws API error
In a UiPath automation, I am trying to get the contents from a report based on summary data from all sheets in a specific folder. I set up the scope and added the Get Report activity with the report ID from the target report. When I run the activity to test it it returns an error: "Error Code: [202] \r\n Message: The…
-
Pivot Table Like UI For Creating Metrics in Sheet Summaries
In Excel you can customize formulas and drag and drop the information you want int Rows, Columns, Filters, etc... via Pivot Tables to build data points and summaries of large amonts of data. If we could bring this functionality to Smartsheet's Sheet Summary with the help of the recent LLM functionalities implemented for…