-
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…
-
Cross-Referencing Assigned To Error
I am building out a roll-up sheet and have everything working nicely, with the exception of a single formula. The part of this sheet I'm having trouble with is in the image below. What I am trying to do is have this sheet look at the person named in the column "Primary", then check a couple other sheets to see how many…
-
Blueprint Summary Sheet Cell Linking Not Keeping Column Type Property
There is a cell in our intake/project pipeline sheet that is a multi-select drop down. It links to a metadata sheet when a project is provisioned and remains a multi-select drop down. But when it's linked to the summary sheet, it's just a text column with all the checked options typed out. I changed the property of the…
-
Automation based on Sheet Summary
Can I set up an automation based on a field in a sheet summary? What I'm ultimately trying to do is set up a review/approval workflow for an entire spreadsheet. Everything I've tried so far (adding status column to the sheet, using a separate summary sheet to track approvals, etc) has been fairly clunky for our team so I'm…
-
"#invalid column value" Error in Sheet Summary
Hello all, I would like to retrieve the date of "LR1" with the following Index Match function (see field 18). Once I hit enter I receive the error message "#invalid column value". Is something wrong with my formular?: =INDEX(Finish:Finish, MATCH([Field 16]#, [Task Name]:[Task Name], 0)) Many thanks in advance for any help…
-
Today() Function not updating
Has anyone else noticed that the today function is no longer updating consistently when sheets are triggered through either cross sheet references or through an automation that records todays date. I have used these procedures successfully for years but in the recent weeks they have stopped working. I can't go back and…
