-
Formula Training
I'm training a guy to support Smartsheet for our company. He's pretty good with most of the functionality, but he has no experience with formulas. I thought I'd put together a training program for him to help him learn them - starting with basics, then building into nested formulas, etc. I want to give him some samples to…
-
Checkbox condition in a child row, conditional formatting of parent?
I have an uber parent row that is the mother of a group of related tests for software QA. In addition, some of the children of that mother have their own children. I would like any parent row to turn red if any of its children fail a test, as noted by a "Fail" checkbox column, and bonus points for conversely turning green…
-
How do i get symbols to appear instead of the word representing a symbol?
Hi, I am attempting to write an IF statement with the result being that the "Pilot Status" cell will have one of the symbols in it. I have formatted the field to show symbols, and I've written the formula to use the representative words, but i'm still only seeing the word show up in the field. HELP My Formula…
-
How can I get the number of checkboxes checked in a single column ?
Hello, I'm trying to get the number of checkboxes that are checked in a given column (more precisely, A10 - Transcode colum) without using another column to do so (in this case, Valeur A10 - Transcode column which displays ''1'' when a box is checked and ''0'' when it's not the case). As you can see in the screenshots, I…
-
Formulas for an automatically generated Risk Level
Hi I'm am trying to replicate the below formulas in smartsheet so it can automatically calculate the Risk Level with existing controls and with additional mitigation. The below formulas are currently being used in excel: Formula for existing controls Risk Level: =IFERROR(VLOOKUP(H7&I7,LikeliConseq, 2, FALSE),"") Formula…
-
Getting Value of Last Row
Hi, I have a smartsheet to track staff working hours and how much time they are up/down based on their contracted hours. I want to be able to get the data in the Minutes Credit/Debit column for the last row (circled in red). The sheet will be added to using a form. I want to be able to pull the number out to put on a…
-
Does Smartsheets have a Google PERCENTRANK function equivalent?
Hello, does anyone have a solution for the excel / google function “PERCENTRANK()” or the “RANK” function. We want to consolidate our roadmap planning into Smartsheets and use one of these functions to automatically score from 1 to 10 each item in the list. The below image shows how this is done today in Google. The user…
-
Individual formula editing changes the whole column
Not sure if this is supposed to happen, but since i was not expecting it at all, i found it extremely frustrating. So i have a spreadsheet that is using several index/match formulas on different columns to pull information from other spreadsheets. But today, one of the Admins on another spreadsheet made me aware that he…
-
sumif multiple criteria
Hi, I can figure out the sumif for the current week but I would like to add another criteria. I keep getting an error could someone help assist =SUMIFS({Week Number}, @cell = (WEEKNUMBER(TODAY())), {Capacity}, {Work Type}, @cell= "Budget") Thanks
-
Auto populate score based on 6 different criteria zones.
Hello, I have been asked to build a scorecard that would automatically insert a numerical score (0-5) based on the input given. So for example, if a perfect score of 100 = 5; 90 - 99 = 4; 80 - 89 = 3; 70 - 79 = 2; 60 - 69 = 1; and 0 - 59 = 0, I would like to develop a formula that would automatically insert the correct…
