-
Changing RYG Balls to Numbers to Create Average
I would like to be able to mark each of these columns using the balls: red (0 value), yellow (50), or green (100), but I want the final column to actually show an average number of the previous columns, for example 65%. Does anyone know a formula that would do that?
-
RYGB formula help
Hi all, I would appreciate tapping into your vast smartsheet knowledge. I am looking to integrate RYGB balls into a formula but I am having trouble linking them altogether. My needs are: When [Actual Ordered Date] is blank and [Architect Approval] is not blank highlight Red ball. I have the following formula working for…
-
Subtask inheriting data from Parent
I've a field for ClientName. I would very much like for subtasks to automatically inherit the Parent Card ClientName value. How might I do this? My users prefer using the Card view. They feel that if they have to use the spreadsheet view, they may as well use Excel. So while I may need to build the functionality in the…
-
I am looking for a formula to return the information in a cell based on date of the entry.
I am tracking safety incidents, none incidents, observations and near misses. I want to be able to transfer the information that was entered yesterday to the cell in the upper right hand corner. The same is true for the information entered today. i will then display this information on a dashboard.
-
IF / CONTAINS using a range
Have an issue I thought I had resolved, but ... I have a sheet that has two relevant data ranges: Range 1 = a single column that specifies a Content Type for each row item. There are 7 possible Content Types: Data Sheet, Ordering Guide, BDM, TDM, Demo, Learning Map, Proposal Range 2 = 15 columns that contain a Product…
-
How do I create a cross-sheet formula to pull with multiple date dependancies?
I am trying to find a function that would pull a value from one sheet to another that is dependent on different effective dates. Basically, I have a sheet with all employees' wages and effective dates. New effective dates show up on different rows. I have several different sheets that show each grant my organization is…
-
Summary Report - COUNTIF of multi-selection columns
I love the way a Summary Report can kinda be a poor man's pivot table within Smartsheet, and it works really well, up until you try to do conditional counts of columns with multiple selections. See below. What's happening here is I want to allow a COUNTIFS when a person is chosen, and count the number of instances data…
-
Nested if/then/and/or???
Hello out there, attaching a screenshot for reference. I'm trying to get the far right column ("Completely Processed") to check under a series of different circumstances: 'Check Cut to Vendor' box MUST be checked for all cases If none of the 'outside $$' boxes are checked and 'Check Cut to Vendor' is cut, then the…
-
Formulas
I have developed a large spreadsheet in which most cells are numeric and dependent on formulas in other cells in the sheet. Formulas do not auto fill when I add rows. If I delete rows, all dependent cells revert to "#Blocked" or "#Unparseable". I am somewhat new to smartsheet, so I"m guessing that I did something wrong…
-
Sumifs - NetSales per product, where the NetSales is in another sheet with product in MultiDropdown
Hello, I have a Product Sheet and one Transaction Sheet. I want to calculate the total NetSales in my product sheet (one row per product) by a SUMIF(s) into my transaction sheet knowing that, in there, the product is contained in a multi-dropdown. I tried the following: =SUMIFS({Master 20-21 Net Sales Y5}, {Master 20-21…
