-
Can you automatically apply a format to parent rows?
I would like parents rows to be formatted bold automatically in my sheet. I looked into conditional formatting but it did not have an option to reconize parent rows. Is there anyway to do this?
-
Using IF to look at a Checkbox field and return "XYZ"
I am creating a Status field using IF function. I'm trying to look at a check-box field and return "status" (ex. "Tooling Complete") if the box is checked. I've tried IF(NOT(ISBLANK(... but a check-box formatted field seems to register as not-blank whether it is checked or unchecked. Does anyone know a different function I…
-
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…
