-
Join Collect formula that excludes the current row from the results
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 number column and including a condition that the list shouldn't include the current row. However, the addition of this to…
-
Lock or Store Date/Value Solution without using Zapier
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'd trigger the copy-row to another sheet and get the created date/other value and then use the VLOOKUP/INDEX/MATCH to get it…
-
Archive sheets and remove access to URL for users not directly shared to the sheet
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 current info which now lives elsewhere). These sheets were previously shared to a larger audience, and a lot of them have…
-
One sheet creation to trigger the creation of a second sheet
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) and attach the 2nd sheet link in the attachments of the original sheet entry.
-
Column Finder
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 listed all columns in alphabetical order so that selecting it takes the focus to that column.
-
#NO MATCH result with INDEX/MATCH formula referencing Auto-Number/System
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 type. We generate 3-digit "reference IDs" in this auto-number column to make it easy to index information for that respective…
-
Getting Data From Another Sheet to Populate in Another Sheet when Conditions are Met
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 "Original" sheet has an "ID" column, a "Status" column (either "OPEN" or "CLOSED"), and "# of Days" column. On the metrics…
-
Conditional Formatting - multiple columns
Hi All, Hope you are all safe. Is it possible to apply conditional formatting to multiple columns (same condition). I have data in 10 columns. I want to highlight cells where the value is not equal to 0. Currently I have to apply conditional formatting to each column separately (cloning the rule). Is there a faster way?…
-
Moving Sheets Automatically
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 moved to an "Old Data" folder in the same workspace?
-
Technical Issues with Formulas in Smartsheet
I am currently experiencing significant technical issues with complex formulas in my Smartsheet. The formulas are extensive and connect multiple sheets, each containing over 3000 rows. Unfortunately, I am receiving error messages indicating that the formulas are unable to access all the rows, and I am also encountering…
