-
Convert High, Medium, Low to numbers (without nested IF statements)?
For each row in a sheet, I need to convert High/Medium/Low IMPACT and EFFORT text into numeric scores like the table below. I know I can do this with nested IF statements, but was able to do this much more simply in google sheets using VLOOKUP or CHOOSE functions: =VLOOKUP(M4,{"Low",1;"Medium",2;"High",2},2,FALSE) /…
-
Apply conditional formatting with formula (Need to populate a cell green only if it falls in range o
Dear Team , Need an urgent help . I want to start using the Conditional formatting on only one cell now the complete row . If you see snapshot below , I want to make highlighted cell (Column Jan and Row 3 i.e. 3Jan) to get green if the value is between (Jan2-(10%Jan2), Jan2+(10%Jan2)). Could you please help on this on top…
-
Pulling data from one smart sheet to another to create chart on results
Hi all i need help on how to pull data together. I need this data to be grouped on a chart to either show qtys or percentage which I cannot do with reports. I have a column that shows my individual products that we are working on and this is abased on a formula in each cell to formulate the data . This column is called…
-
Required vs. Completed formula help
I think this is an easy one but my brain is not firing correctly today. I need a formula which will compare how many tasks in the "Required Milestones: OT" have actually been completed. So I have my formula for the required tasks =COUNTIF([Required_Milestones]:[Required_Milestones], "OT") but how do I get it to look at the…
-
If Formula with a Dropdown List
I have a column titled Status that includes the following drop down selections: Not Started, In Progress, On Hold and Complete. I want to write a formula that based on the drop down selected, another row would populate the following automatically: Not Started = 0%, In Progress = 50%, Completed = 100% and On Hold = ON HOLD.…
-
Need help with a formula that is using data from 2 columns
I have a column called Building Turnover and Scheduled - Days Out. Schedule days out takes turnover - today to get a number. I want to see the value and if the value is <30, I want to add 15, if it is I want to add 30. I want all of that in another column Can you help? =IF(OR([Scheduled - Days Out]@row1< 30, [Building…
-
AVG cells with cell references that contain formulas and numbers
Hello- I am trying to avg a group of cells that reference formulas in other sheets and some that only have numbers entered manually. Any advice on what I should do? see screen shot- thank you!
-
Default value from the dropdown list
Hi Everyone! Here I have a dropdown list of a markup values, how can I set the default value to [15%] whenever I add a new row without the need to do it manually? Also, when the user chooses the Custom Markup option, can I make it in a way that the user enters a specific value after choosing the custom markup option? ( I…
-
End of Year Weeknumber Issues
Hi, I'm having issues with many of my weeknumber formulas, now that it's the end of the year. I have a Start Date column. I want the weeknumber of three weeks after the start date. Until now I used =WEEKNUMBER([Start date]@row) + 3. That doesn't work for the end of the year, because after 53 it goes to 54, 55, 56 ect..…
-
Count Progress Within a Specific Parent Section
Hello, I am new to Smartsheet so I may not be using the correct terminology. I am trying to count the number of tasks set to a certain "Progress" within my project sheet. Ideally, I would like to break up this count by the different parent sections we have set up (Government Officials, Healthcare & Medical Offices,…