-
Automating the addition of a task list to a sheet
My department is working on a change management process, the steps of which will be standardized for each change. We're using a web form and alerts to notify the team of a new change request, and managing the workflow with a separate sheet. Is there a way in the workflow sheet to populate the list of tasks without having…
-
Can we show Sheet Summary data on sheet itself to avoid inputting data twice?
Project Sheet 1 and Project Sheet 2 have detailed data. Sheet_report_summary pulls the "Sheet Summary" data (icon in the right pane) for executive summary. In our engineering meetings, we drill down into the details of each sheet. Can I show the "sheet summary" data on the sheet itself? For example, a project is RED-…
-
IF Statement - If two columns match any two columns on the page, flag it
Right now I have =IF(COUNTIF([Part Number]:[Part Number], [Part Number]1) > 1, 1) If the part number in row matches up with another row, it lights up a flag. I want to be able to add two checkpoints... If a "part number" and "ware" in one row matches up to another "part number" and "ware" on a different row, light up the…
-
FILTER
Hi, Please can someone suggest an dynamic alternative for Smartsheet to the FILTER function that Google Sheets have to include in a report. I have a list of Asset I.D's that have multiple statuses at any given time. I would like to capture each Asset I.D assigned to each person according to the Asset's status. ie: all…
-
Conditional formatting to alternate shading of rows based on a field
I've created a sheet to track an IRB's review of projects. Each IRB committee member fills out a form as they review each project, then they use the sheet that's populated by the forms when they meet to review multiple projects. I want to make it easy for them to see at a glance what the responses were for each project,…
-
Show Conditional Formatting/Cell format on Automated Alerts
I have built an automated alert that determines which columns to include from a large Smartsheet which uses the max 200 columns based on a number of parameters held within certain rows on the sheet. This works well. However the issue I have is that I have conditional formatting contained within certain columns in the…
-
Filter suddenly not working
Hi All, I have an issue of a filter not working that previously worked fine. The filter looks for cells in a column formatted for text/numbers. Here's an example of the data in the column: NLOND_3104-1 NLOND_3709-2 -2 -1 -2 NLOND_5612-1 The filter looks for data that contain -1 and another filter looks for data that…
-
Remotely fill in a new row on another sheet.
Hello, I have two separate sheets that need to be connected. One is an inventory sheet of all raw materials in stock, and the other is a record of all raw materials delivered. If we receive a delivery of a type of raw material we already have some in stock of, the quantity of that material is simply updated in the…
-
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…
-
formulas
When I am trying to add several variables using =sum( formula and scroll to locate other variables, my formula is cancelled and I receive an error code. As if I can only use variables/amounts on desktop screen and not above or below.