-
Check Parent if All Children are Checked
We use Smartsheet to house our product bill of materials across all projects. I would like to use a formula to populate in the parent row (sub-assembly) that would flip from an unchecked box to a checked box if all the children are checked. This is a parts received column so this would populate a report for our assembly…
-
How do we get our hyperlinks to work properly?
We are currently working on a sheet where if a specific number is entered in a cell, a corresponding hyperlink will be next to it. We have a sheet for hyperlinks and the IDs that are associated with them so that we can use a formula to pull that link when it sees its code. Our issue is that even though our links are…
-
Sum If
I'm trying to do a sumif calculation that returns the dollar amount that was overpaid. I already did a simple formula of =[Open Balance Amount]@row - [Amount Paid ]@row. I wanted to know if its possible to show as a plus amount vs negative(-) amount
-
From another sheet, how can i lookup / pull a list of values ?
Hello world, I have two data sheets that both have columns that contain a identifier for what the row references. I want to make a list in my third sheet that contains all the identifier values of these two data sheets that meet my criteria of containing letters xx in the end of their identifier names. Is this possible?…
-
Having Formula Troubles
Hello, I am trying to count a certain number of product types within a certain work week, both referenced in other sheets. I am able to count my work week data for all product types in one column using =COUNTIFS({Calculation - Defect Rate Run Chart Range 1}, =[Work Week]@row) I have another cell that I am trying to grab…
-
How do I list projects from a specific department across multiple cells?
I have a Smartsheet where one sheet contains a list of projects categorized by departments. Each department has multiple projects listed under it. I need to extract and display all projects from a specific department in another sheet, with each project listed in its own cell vertically down the column. I've tried using…
-
Ranking Prices by Name - Need Formula Help
Hi, So I can't seem to figure this out. Below I have the name of a manufacturer with how much we are spending with them in no particular order. I'd like to use a formula that tells me, in decending order, the top 10 manufacturers we've spent the most money on. I would need the information to be listed like below STERIS…
-
NETWORKDAYS between a date and a number
How does it work to minus a number of days from a date cell using networkdays? One column is a Due Date that I would like to populate based on a set date that will be static in [Due Date]9 cell I put in the Due Date column =[Due Date]9 - 180 (works fine, and gives me the result of a date based on the cell [Due Date]9 minus…
-
Trying to pull data within a date range - need assistance with the formula
I'm attempting to collect data across sheets and am having a hard time getting my formula right. I want to collect the number of sites in a program that falls into a particular date range. So, I want to pull from our intake sheet all sites in Program A that are due between 1/9/23 and 1/13/23. I've tried a couple of…
-
Column Properties using Symbols
Anyone here used the 6-state Pain Scale in their sheets/dashboards? We plan on using this for our customer satisfaction survey and I want to know how you guys came up with the formula. If there's an article available around this might be helpful too. Best, Grace