I am sure there is some simple answer, but I brain hurts. We are developing calculations and metrics to quickly assess the status of a project. I am trying to find the percentage of Critical Path task…
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. Her…
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 wan…
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 followi…
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) Co…
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…
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 ta…
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 a…
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…
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. =DATE…
