-
Linked cell skewing formula result
I am trying to write a formula that checks for 4 criteria; a. That the result in cell [Transition]38 = "Transition" b. That cell [NPS %]38 is not blank c. That cell [BG KPI]38 is not blank d. That cell [LE CM %]38 is not blank If all 4 criteria are met, then YES, otherwise NO. Of the cells referenced above, only [NPS %]38…
-
filling columns -has to be a better way!
I have a schedule with close to 2000 lines. I am adding columns that need calculations in them. It currently takes me close to 15 min to either drag the formula down or copy and paste chunks. When I create the column why not provide me an option to enter the formula then and apply that to every row? Smartsheets has been…
-
Parent Row Symbols based on highest priority?
It is possible to create a formula that will change the symbol to represent the HIGHEST level out of the 4 rows? IF the (HIGHEST) Risk Level for rows 1-4 is "x" THEN action for symbol column is "low" = blue symbol is "medium" = green symbol is "high" = yellow symbol is "extreme" = red symbol I currently have a formula to…
-
speed of sheet
I solved it never mind. Thanks if anyone was looking at this. I have a sheet that is moving very slowly, in fact the entire page doesn't seem to work when I have the sheet open. It is less than 30 columns and 100 rows, however it has many lookups and column references due to the nature of what I am trying to do. below is a…
-
Count the number of projects in a folder
Our team is looking for a way to count the number of projects of three distinct types. I have them located within three different folders. I do not want to have to use cell linking. A user should be able to create a new project without having to open a summary sheet and create a new cell link. If I could use a formula in a…
-
Formula Help
Below is a screenshot of the sheet that I am trying to create a formula on. What we need is a formula that will calculate the Quantity x Unit Price + Extra Charges = Total Price. BUT we only need this calculation if Fixed Quote $ is blank. If Fixed Quote $ IS populated then we need that value to populate in Total Price.…
-
Count Number of Children Cells that are not blank.
I'm having difficulty with this one. I have a parent row of "Rental Lead" I would like to count the number of child cells in column "Training Course" under the parent "Rental Lead"
-
IF Statement Help
Hello, I am new to Smart Sheets and apologise in advance if this is a simple question... Scenario: I have a sheet that is updated via a Web Form and i would like to have a Job Status updated depending on a few conditions: IF the Operator is equal to Unassigned then the Job Status is Unassigned IF the Operator is not equal…
-
Cell Linking Autofill or other means when sheet too big
I sent in a comment to Customer Success that the sheet is getting slow performance. The response was bust it up into multiple sheets. Well I like the idea, I'm not sure I like the solution - it make everything now manual unless someone can tell me a better way. The first four columns in my Master Sheet would need to be on…
-
IF / THEN FORMULA HELP - Multiple Numerals
How do I create a if / then formula to show one response for multiple numeral answers such as IF Column1 is 1, 2 OR 3 then Column 2 is "acceptable" 4, 5, OR 7 then "tolerable" 6, 8, OR 9 then "undesirable" 10, 11 OR 12 then "intolerable
