-
Average Collect Issues
Hello! I'm trying to write a formula that will average the amount of time a type of request takes to complete by month. I'm referencing another sheet in this formula and just can't get it to work. Here's what I have so far: =AVG(COLLECT{Hours to Complete}, ISNUMBER(@cell), {Request Type}, "Quote Request", {Submitted Date},…
-
multiple VAT % sum
hello all I think this simple but I cant get it right for sum reason I have 4 columns VAT % , NET Price and VAT, plus Inv total basically VAT % has a drop down of different vat charged 6 options I want my formula to look at option picked in column 1 (VAT % ) and the amount in Column 2 Net price to tell me in column 3 ( VAT…
-
IF Formula with Multiple Criteria
Hello! I have a software enhancement sheet, and I am trying assign priority to each enhancement based on the level of effort (LOE) + change priority calculated score. The LOE can be one of the following: 1 - Unknown, 2 - High, 3 - Medium, 4 - Low, 5 - None The change score change range from 4-25 The breakdown for priority…
-
Overall Project Status based on frequency?
Hi, So I have the following sheet set up for projects where each Group may have more than one project in different statuses: The order of status are the following: 1) Started, 2) In Progress and 3) Completed. I am trying to set up a formula that will return the most frequently populated Status per unique Group and also…
-
Help with a formula to count how many projects with a brand have the status of "approved"
Hi there, I'm trying to figure out how I can count the number of projects for a brand have a specific status out of the total projects for that brand. Also, I'm referencing a different sheet for these formulas. I already have the formula to count how many projects are associated with a specific brand, but now I want to set…
-
Can index+match be used to add values together?
I'm in the process of creating a series of sheets to track weights submitted by a variety of people. The people are going to be categorized by 'team', and I already have an index+match formula that takes their submissions and automatically organizes them to like a main row per person, each value going into the column for…
-
Is it possible to add a new line in a Formula?
I found this discussion from 3 years ago: https://community.smartsheet.com/discussion/adding-carriage-returnline-feed-calculated-text It got a response from the community manager, so I would like to assume 3 years later it was implemented at some point Is there a way I can do this?
-
So i want to know how can i sum up purchase requests based on dates
I know how to do it with COUNTIF({2023 dates }, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2023)) How do I change this to add the SUM of purchase requests that only falls in quarter 1 of this year, and i can then do it for Q2, Q3, Q4
-
DATEONLY as a column formula
Hi, Is there a way this formula could be modified with @cell so that it could be converted to a column formula? I can't convert this formula to a column formula as it references a specific cell. =DATEONLY(Created77) Thanks, John
-
Help - Trying to Write Simple % Calculation Formula
Hello everyone! I'm trying to write formulas to help create visibility into a department's KPIs, which will eventually feed into a Dashboard. I'm fairly new to writing Smartsheet formulas and have been struggling. I need to reference 2 main columns (Role M1 Actual & Role M1 Goal) in my formula to deposit the result in a…
