-
Why are my sumif values different on my "sheet summary" than they are on my separate sheet?
I have a sumif formula in my "sheet summary" that is giving me a correct value when summing my values on that sheet. My formula is: =SUMIF([Project Status]:[Project Status], "Active /WON", [Project $ Value]:[Project $ Value]) When I use the sumif formula on a separate sheet referencing the same data I am getting a much…
-
Column Formulas in SUMIFS
Hi there, I'm currently using a SUMIFS formula that is as follows: =SUMIFS({v4 Hours}, {v4 end}, MONTH(@cell) = 12, {v4 Group}, OR(@cell = "AD", @cell = "Freelancer")) I want to sum the task hours column {v4 Hours} if the End Date for the task is in December, and the group has one of 2 values. Each {reference} refers to a…
-
Help with formula using weeknumber
Hi all. I think what I am looking for is a weeknumber formula, but I've having trouble figuring out how this will work. I have a sheet that lists 31 "fundamentals" of our company. Each week we have a different fundamental to focus on and will be discussing said fundamental at the beginning of meetings. I have sheets for…
-
Is there a formula where I can identify first item alphabetically in a list?
For example, if I have a list of names and projects, I would like to identify the first name alphabetically for each project. In the image attached, Alex and Jane should be the first people alphabetically for their projects. Is there a formula that could evaluate a text range and determine which value is first…
-
I want to add columns with checkbox ticked and return a number
What would be the formula to calculate checkbox ticked and return a number 2 when checked 0 when unchecked? Thanks
-
How do i track progress based on output?
I have a project that involves building fences in a number of locations. Each location has a budgeted lineal distance of fencing, and we will need to track progress of distance completed against budgeted. I can do it in an excel spreadsheet, but would like to have it as part of my smartsheet plan. Am new to smartsheet!…
-
Nested If Formula
Could someone please help me with this IF formula? Much appreciated! =IF([Total Individual Miles]1>350, "Five", IF(Total Individual Miles]1 <= 50, "One", IF(AND([Total Individual Miles]1 >50, [Total Individual Miles]1 <=150), "Two", IF(And([Total Individual Miles]1 >150, [Total Individual Miles]1 <=250, "Three",…
-
Display Year in a 10-Year Cycle
I have a sheet that is used to track where a store is at in a remodel cycle. Currently, I just have a column that takes the later date of two date columns, and adds ten years for an estimated remodel date. I'd like to add another column that displays the year in that 10-year cycle. In this sheet the Future AF column takes…
-
Formula in % Allocation Column?
I am certain this has been asked either currently or in the past, but is the capability to include a formula in the % Allocation column on the product roadmap? Right now, I have a column entitled "% Alloc Calc" next to the "% Allocation" column to calculate the % Allocation for my users. The users must ensure that both…
-
Locking a Sum Formula
Hello - I am wanting to lock a sum formula and am not sure exactly how. Do I need to add additional aspects to the formula beside the "$"? The issue is people are moving items around in their timesheets which adjusts the below formulas and I want to make sure if they do this, the formula will not change. Below are the two…