-
Need Help with formula: One of 3 values based on a high and low threshold
Trying to set up a formula (IF?) where the value of a cell is either 0, 3 or 5 determined by the value of a result and if it is below a minimum threshold, in the middle or above a high threshold. For the attached example, the first KPI result is 100% so it receives 5, second result is 4 falls in the middle so receives 3,…
-
Referencing Another Sheet: Count
Good day all: I am counting number Rows in another sheet. However, I do not want to include the Parent or Grand Parent Row in that count, just the children and grandchildren. thoughts on how I would structure this formula? Thanks My formula =COUNTIFS({Mi-Config 7.2 WBS Range 1}, 1)
-
Counting Unique Values based on a date criteria
I am using this formula to count for unique values within a range of cell. I want to be able to use a criteria, a date for the range of cell, what should the formula look like? =SUM((IF(FREQUENCY(MATCH(B2:B16,B2:B16,0),MATCH(B2:B16,B2:B16,0))>0,1)))
-
Totals By Date
Hello, Has anyone successfully used dates to pull totals? I'm trying to do the following: Columns: Start Date | End Date | Status 1/2/18 1/10/18 Completed 1/5/18 1/7/18 Completed 1/5/18 Open 2/8/18 2/15/18 Completed 2/16/18 2/20/18 Cancelled Output: Total 'Completed' for January 2018 = I'm wanting to use the dates and…
-
At Risk Flag - Past Due
I want to use the "At Risk" Flag to populate when an item is not marked complete and is past due. I assume I need to use an AND or and OR formula - but this isn't working. The formula below yields no populated flags. The line for "Tag Drawings" should populate a flag because it is past due and is not completed.
-
Checking what Months are during a Project
Hi, I've tried to find a solution for this, but maybe it's a too generic wording problem. We have a Master Project list, that has the start and end date of every project we have, as well as it's budget and projected profits. I want to have an overview of how much money is allocated to each month and for that I need to…
-
Multiply
Hey, What is the smartsheet furmula for multiplying so far i tried =Skupaj ure za tekoči mesec1 * Urna postavka1 =[Skupaj ure za tekoči mesec]1*[Urna postavka]1 i am trying to multiply monthly hours and hourly rate..... no problem using excel.......
-
SUMIFS formula
=SUMIFS({Completed date}, MONTH(@cell) = [Jan 2018]$1, {S/S}, AND({Rep} = "Paul")) Hi All, Trying to get the above formula to work. Referencing from another sheet. Want to be able to match a sales reps figures per month. From these columns in the other sheet: Completed date column, Invoice value column and rep column. So…
-
Dashboard and Sheet Not Updating Cell Referencing
I have a sheet with multiple countif formula referencing data from multiple sheets. From this single sheet, I have created a vital live data dashboard for multiple users to view and make decisions based on it. However, when I log back into my for some reason I see the totals in the dashboard reflect old data, and when I go…
-
Mod function substitute
I am creating a due date field that will auto update for a Dashboard. The goal is that every 2 weeks an updated date will be shown. From what I can see MOD is not supported in Smartsheets. I am wondering if someone is able to help me with a mod substitute on a date field like I have done in Excel. The formula in Excel is…