Sheets
Discussion List
- I've been digging through community for resolution to this issue, but I'm coming up empty. I need to be able to copy/ paste multiple rows of data that have "multi-row (alt+enter)" information from Exc…
- 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 cou…
- This discussion has been merged.
- 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…
- 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 tr…
- 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 "sof…
- 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 di…
- 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 …
- 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 …
- =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…
