-
Formula to Calculate Percentage Change from Baseline
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…
-
Countif a name from a list of multiple names
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…
-
Assignee reporting for all tasks during specific date ranges
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…
-
how to set up info sheet to feed into Resource Management
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…
-
Unable to Convert to Column Formula
Using this formula Smartsheet isn't letting me convert to a column formula: =[Material Received]@row - [Purchase Date]@row - [Lead Time (days)]@row
-
Multiple IF statements
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!
-
Formula Remediation
I asked the AI tool in Smartsheet to help create a formula that achieves the following (the name of the "Engineer" has been changed for discreteness): i want to create formula that would give [Lead Allocation] * [WIP Revenue] when [Engineer Lead] is "Bob Smith" and otherwise give 0, but I want this formula to sum it up for…
-
I need help with the RYGB Status Balls formula
Hello, I am trying to calculate health status (RYGB) for each task and milestone. Red= Not Started and past due, Yellow, In progress, but % complete is equal to or lower than 48% (.48), Green is in progress, % complete is equal to 60% or greater and blue is completed. I have read through many posts, but cannot seem to find…
-
COUNTIF between date range and 2 criteria
I am trying to cross reference another sheet to count all of the projects assigned to a specific person in between a certain range, but the # of projects assigned and the person assigned to the project are 2 separate criteria. For example, I want to know how many "A" projects that Jane completed in the month of January. I…
-
Report Parent, Child, and all Children under a Specific Parent
I've attempted to create formulas and helper columns to accomplish my task, but I must not be understanding how to get to my desired conclusion. I would like to take a subset of my overall project plan and report that based on a set of criteria. The challenge comes in that I want a scalable solution and I would like to…
