We are making a master sheet to combine all of our 15 intake forms and sheets to help track metrics and more easily send intake rows/projects amongst teams once their portion of the project is complete and/or work on a project simultaneously. Is there a way to only view the columns for each sheet and their column…
My formula shows average of .3625 (rounding up won't even help) The sheet shows average of .97 (which is correct). The values outlined in blue are MS
I have a column chart as seen below: The summary sheet i use as the data source is formatted as below: I used a summary sheet instead of a summary report as it gives me more options to manipulate the data, but also structure it correctly in terms of month order. The months and years will have to manually be inputted and…
Hi, We capture scores between 1-5 each month. I'm looking to create a formula to calculate the percentage change from the baseline based on the most recent month's entry in that row. For example, baseline (starting) score was 3 in June (captured in the column "June"). Let's say it's now August and the score is 4 (captured…
Greetings- I need formula help to count a name EMMA that is selected from a drop-down that has other names selected as well. Basically I need to county if Emma's name is listed in the Education Naturalist column that has other names included in the same cell. If I use =COUNTIF({Program Survey Range 1}, "Emma") it will only…
I have been trying to create a report that shows all the tasks my team have on each week. I found some guidance in a community post about setting filters based on the start and end date. However I have found this doesn’t provide quite what I need so I was wondering if someone might be able to help me. Basically, I want to…
I have entered this data and am using it as a way to track allocations across different projects. The different projects are indicated by the different WRT #s in column 1. I need to then summarize the last 2 columns by WRT #, which I've done here in a report. I am wanting to add some type of flag or conditional formatting…
Using this formula Smartsheet isn't letting me convert to a column formula: =[Material Received]@row - [Purchase Date]@row - [Lead Time (days)]@row
Hello, I'm trying to make an IF( formula for the following criteria. If Tech is YES and Curved is YES, 650 If Tech is YES and Curved is NO, 500 If Tech is NO, 0 Thank you!
