I have a sheet where employees submit information to me. I created a helper sheet because I want to see all of the employees who submitted requests 2 or more times in the current month. Is this possib…
Hi there, My consulting company uses Smartsheet heavily and has been using Resource Management to track budgets, hours, fees, and time entries. Within that, I've encountered a challenge and I'm hoping…
I'm trying to create a formula that creates a list of duplicates in my sheets, I've gotten this formula to work but it's showing the original row within the list of duplicates. I tried adding an auto …
Hi all, I hope you're well and safe! I've developed a solution that lets you store the date or value. You'd use the copy-row automation and a VLOOKUP or combination of INDEX/MATCH to make it work. We'…
I have a few sheets that have been created that I need to archive to only be accessible by a few people who are shared directly to the sheet (sheets are used for reference purposes but don't contain c…
Response to Pro Desk 07270893 session. I have a form set up that creates an entry into a sheet. I am looking for when the form creates the entry into the sheet, to trigger a 2nd sheet (different sheet…
Provide a better way to find a column in sheet. For sheets with many columns, it is sometimes difficult to locate the column that you are looking for. It would be better if there were a dropdown that …
I use the INDEX/MATCH formula across many of my sheets for many years. This is the first year I've encountered this issue: my formula is indexing information referencing an auto-number system column t…
Hello, I currently have 2 sheets that I am working with: the first is the "Original" sheet and the other is a "Metrics" sheet, which pulls data from the original (being used for Dashboard charts). The…
Is it possible to set up a workflow that moves an entire sheet or report once certain parameters are reached? For example: if SheetA hasn't been opened in the last 3 months, can it be automatically mo…