-
Updating Rows on different sheet assigned to a user?
Dear All,new here, apologies if this has been discussed before, couldn't find anything. A question regarding the following scenario: Imagine a sheet (sheet 1) in which a user/department ads their requests assigning a task to a specific user/owner. Is it possible to update the sheet of the owner only when a task is assigned…
-
Circular / Blocked Reference (Vlookup)
I have a problem with 2 sheets reading each other’s data through a VLOOKUP. The same problem was posted on May 30, 2018 by scott.barrett. Obviously it is not solved. My sheets also work perfectly for periods of time, and then start returning #circular or #blocked data without any changes to the sheets in almost every 2…
-
summing totals, referencing multiple sheets
Hello, everyone. I am using Smartsheet to organize our company's sales projections. Each of our product Distributors (9 total) have their own sheet, with case sale projections by Product and Month. I am interested in making a summary sheet, that pulls the case totals from each Distributor sheet, for each Product, again by…
-
SmartSheet connectivity via ODBC
G'day We are looking at the possibility to migrate our project meeting minutes from Excel to SmartSheet. The Excel-based minutes have columns that pull data from different sources, being Sage and Dovico via ODBC (extracted data is in another tab within the Excel file), is the same possible in SmartSheet? If so, would…
-
Formula to track % complete of a fabircation component in a row
Good evening, I will try and explain this without messing up * We are using smartsheet to track fabrication of product * each row is an item we fabricate * each item has a budgeted amount of time per task designated in a column * they are python, fit up , weld, unload, and admin * the sum of alloted time is *…
-
Removing Multiple Link
I have created and tested a few examples of the master sheet where it links data from two base sheets. The bases sheets are maintained by my team and I don't require any changes. I have successfully done so but due to me testing a few times, the bases sheets are showing, each cell, data is outbound linked to <unknown…
-
Calculating Totals
Dear all I deal with importing goods from all over the world, and payment usually happens in multiple currencies. In smartsheet, I have a column for currency (USD/Euro etc) and the next column I have the amount. What I am looking for is a payable total in each currency, E.G. For Payable euro, the formula will look at all…
-
Linking Cells and then Sorting Source Sheet
I am working on creating a master list of events, that pulls data from 2 source sheets. I worked out the linking, but when the source sheets are re-sorted it messes up my links on the destination "master list". Is there a way around this? The source sheets are not able to remain static pages and will be used and updated…
-
URL to jump to a row in a sheet? Unique identifier for sheet-row combination?
I am looking for a way to have a URL that will allow me to jump from an external source to a specific smartsheet row. For example, if I were to have a Google Sheet which I was doing some calculations and I wanted to have a link corresponding to each row in a Smartsheet to let me click on that link and go directly to that…
-
Harvey Ball formula that reads across and produces cumulative
Hi All - I would like a formula that reads across vs vertically - here is my vertical one. I need the same thing but read about 10 columns status to then come up with an overall status meaning if there is 1 red, 7 yellow and 2 green then the overall cumulative status is red (lowest common denominator) Vertical Formula:…
