-
Countif but only if?
So I am trying to count the number of times a person worked on a specific task. I have various "types", each person might have worked on the task in a different role (Lead SME, SME 2, SME 3), and then I have a check mark whether or not it should be included in the "tally". Ultimately, what I am trying to do would be if the…
-
Counting Quantities of Numbers
I am trying to build a column to count the # of times a predecessor appears in the predecessor column. The below formula has almost gotten me there, but it is also counting predecessor cells that include 1, but not exactly 1 (like 12, 21, 100, etc...) =COUNTIF(Predecessors:Predecessors, FIND(1, @cell) > 0) Is there any way…
-
RAG Status - Formula
Hi, I have currently formulated the following formula, =IF([% Committed to Date]1 - [Project Status %]1 < 0.25, "Green", IF(AND([% Committed to Date]1 - [Project Status %]1 >= 0.25, [% Committed to Date]1 - [Project Status %]1 <= 0.75), "Amber", "Red")) which is working efficiently, but problem occurs it shows me the…
-
Formula Help!
Hi, I'm new to Smartsheet and the community. I am trying to trigger a flag on my sheet to alert me when: - The status of my project is not complete, 5 days before the end date - The status of my project is in progress, but less than 50% complete, 5 days before the end date The below both work individually but I'm having…
-
Counting total based on Status & Date
Hi, I'm trying to calculate the total value of all the won job in this financial year. I have to reference 3 columns for this (Date submitted, Value, Status) not sure how to make the formula. This is as far as I got. Please help. =SUMIFS([Tender Due]:[Tender Due], >DATE(2018, 6, 30), <DATE(2018, 6, 30), Status:Status,…
-
Symbols Formula. How do I make a symbol depend on two other columns?
Hello! I am trying to make a symbol formula that will become "1" (red flag) IF the Start date is in the past, AND if a dropdown list DONT show "Done". Anyone that has this formula or knows how to write one? Kind Regards// Hugo Martinwall
-
VLOOKUP return the second value that is finds in the table
Hi, I am looking for a formula that can return the first, second, third ... value in the table. Using Vlookup will only return the first match Any suggestions!! Thanks Fadi
-
Date Calculation Question
Can anyone share with me on how I can calculate what I call the 'Next Quarter Projects'? For example: I have a start date and end date columns for each project, and I want to create a Filter/View that shows me the projects that are due in between a date range(ie Q2, Q3, Q4, etc) Can anyone help? Thanks!
-
Help with cross sheet formulas
I have a property list setup that contains floor plans and costs for those floors. In another sheet i have a column setup as "bill rate." In the bill rate column, i would like to write a formula that would go to the property list sheet, search the property name column, match the floor plan and cost of the floor plan The…
-
Calculate a conversion rate on a specific date
I have a budget that has expenses in both USD and EUR. I report expenses in USD to our finance department. I'd like to be able to calculate the euro to usd conversion rate for the date that something is paid. Is there a formula not to pull the current conversion rate, but a conversion rate from a specific date, in this…