-
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…
-
Alert/Notification when line item hasn't been added
I am building a sheet in which 6 managers provide updates in the form of line items. Each week our Director reviews this sheet for the latest updates. I am looking to create a notification system that would go out to each manager that doesn't provide at least one update (add one line or modify an existing line) in the last…
-
Is there a way to delete a cross sheet reference?
I had a working formula referencing another sheet. It was referencing a set of cells in a column. I changed it to look at the entire column and started getting an #Incorrect Argument Set message. I tried to change it back to the range of cells and I'm still getting the error message. I wanted to delete the cross sheet…
-
Average symbols for growing number of columns
Hello all, I know this is likely possible, but I've been struggling to think of the most efficient process. Below is a sheet I'm working on, where trainers enter progress for a trainee in a given "soft skill." These trainer columns will be added automatically on a daily basis via an outside Power Automate flow, while the…
-
Streamline Sheet Reference Manager
I just went through an update where I needed to manually add 3 new sheet references to 26 Stakeholder Registers (78 total). I wish that after you click Insert Reference, the Sheet Reference Manager dialog box would remain open.
-
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…
-
Add to Calendar for event registration
We are currently using Smartsheet to build reusable templates for events that occur multiple times a year and will continue for years to come. One frustrating thing that Smartsheet is lacking, is the add to calendar feature. Adding this feature would allow users to include the zoom, teams, or whatever meeting platform they…
-
Why is my formula unparseable?
=IFERROR(COLLECT([Completed Date] - [LTP Conversion Date], AND(IFERROR(MONTH(@cell), 0) = Feb84, IFERROR(YEAR(@cell) = 2023, 0)), {CAD Support Type TD}, ="Long Term Project")), "N/A") The bold is what I want to subtract within the formula.
-
When a form is submitted I want to add 3 children task underneath each request
Hi, How can I achieve when a request is submitted I want to add 3 children task underneath it. so that when ever the request is submitted I have predefined user task(repetetive same)task that needs to be completed Thank you in Advance. Thanks, Radhika
-
"When Triggered" Automations Behaviour
A colleague of mine has sent me a question that has stumped me and has got me thinking my understanding of how automations work has been wrong. She sent me the following: We have automations that are set up to send when triggered that send emails to support when someone requests access to one of our products and also a…
