-
Help! Already reached Vlookups Max reference Cell count of 25,000
I need a solution to the vlookup max reference cell count of 25,000. I have a database that zapier loads data too from an application. The database consists of 134 columns, and will grow to an estimated 300+ row count. Which works out to 39900 cells, which is 14,900 cells over the limit. I use a summary sheet to gather…
-
Vlookup from Excel to Smartsheet
My apologies if this has already been covered, but I didn't see anything specific to this subject when searching. I have a Excel sheet that has 45,000 + rows. The data in the rows are filled by 2 columns - United States Zip Code's and city's linked to those zip codes. This Excel sheet is used as a vlookup for multiple…
-
auto completion date
Hello, fairly new to Smartsheet and I have a question. We have a sheet for PO requests and one of the columns is for "Status" , it has several options from a drop down menu. What I would like is for our "Completion Date" column to automatically show the date when a status is changed to "Complete". I don't care about any…
-
Column not auto-filling with formula
Hello, I am having a webform insert new rows at the top of my spreadsheet. As you can see in the picture, for some reason the formula in the third column automatically fills the new row, but the formula in the second row does not. Why might this be? Thanks!
-
Additional workflow/automation actions
Scenario: In our project, we have a weekly reporting cycle. In some of our sheets, we have a field that is "previous status" or "previous actions" or other similar ones, you get the idea. Desired action: have an automated flow where, once the end of the cycle is reached (any configurable date, friday evening for example),…
-
Drawing row linked data into another sheet together?
Hi All! So I have a sheet with a list of tasks, a checkbox for completion and a due date. In one of my other metrics sheet, I am trying to generate a list of my top 5 overdue tasks. I have managed to get a list of the most overdue dates with a SMALL(COLLECT...) function which will only count dates that are not listed…
-
forms and cell linking to a secondary sheet
Hello I have created a Time sheet form that i sent out to 11 employees to gather all the daily info. This form fills in the Time sheet Smartsheet. We want to keep the Time sheet Smartsheet as a master sheet and strictly for data collection so that no one messes around with it and looses anyones time. Ive been trying to…
-
Automatically transfer data entered in one sheet to other sheets.
Hello Everyone, Does anyone know if it is possible to create a master sheet, then once a row is added to this sheet, the same row (With only specific columns) could be automatically added to another sheet(s) ? Your help is Highly appreciated. Thank you, Hamza
-
Will changing a sheet name break the cell links?
I want to change a sheet name, but it is the source sheet to another sheet with cell links. Does anyone know if the links will break, if the source sheet name is changed? Thank you, Bill
-
Hyperlink to a network drive
Hi - I have a document stored on a shared network drive that I would like to be able to insert a hyperlink to. Is this possible with Smartsheet? The sheet appears to only accept web addresses as hyperlinks rather than file locations (for example: Z:\Documents\File.pdf). Uploading the document to a cloud storage provider…
