-
Want sum calculation in report - Formulas in reports?
Does anyone know if there is a way to add a formula for a report? What I want to do is sum the values of a column for all rows returned for a report and to add some sort of highlight when the sum exceed a certain value. Specifically, if the amount of hours for a list of tasks for day assigned to a given person exceeds…
-
Check if Child Row
We use the formula =IF(COUNT(CHILDREN()) > 0, 1, 0) to check a box if a row is a parent row. This is a helpful tool when using conditional formatting to format rows which are parents, automatically. We'd like to do a similar thing if a row is a child row, but I cannot think of a way to do perform this logic. Has anyone…
-
Using IF formula to set conditions for RYGB ball color
Hi there! I have been trying to set conditions with a formula to change the color of a RYGB ball based on two columns, the percent complete and the due date. I wish to use the RYGB balls and not just change the color of the cell, which is why I'm using formulas instead of the conditional formatting. I keep receiving the…
-
Help with date formula/automation
I am trying to help a user automate a current process in Smartsheet. The information within the sheet is compliance info and each item has different regulatory rules. Some items have monthly update requirements, while others have quarterly or annual update requirements. Right now the sheet admin goes in the sheet to see…
-
Webform Help
Hi Team! I use web forms to a large degree now for installation sign-offs for our field engineers, they are working great. Is it possible to build a conditional branch into a webform? So if I ask a question "Are you proud of the installation?" This is answered via a YES or NO dropdown option If "NO" is selected Can the…
-
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…