-
COUNTIF formula counting specific criteria under a PARENT row
Hi All, I have a shipping tracker I created for six different stages we're doing for a project. I need to create a graphical representation of the different statuses for each stage and type. The formula would read: Count of "delivered" for "POM to IHA" under "WW01, as one example. A separate formula would be Count of "In…
-
Count how many within a year
Hi All, I have column title named 'Type of Request' and you can click multiple answers, so a cell can contain 1 or maybe 4 answers for example... . I have another column called 'Date Created' which is the date of the request. What i am trying to do is a formula that will tell me how many requests we have had within the…
-
Totals and Sub Totals
Sorry if this is an obvious question but I am new to Smartsheet and I am trying to get my head around Totals and Sub Totals. In our Project Plans we have 3 columns relating to Effort: Planned Effort Time Spent Effort Remaining What I need is to be able to get a Total for each column in say Row 1 and Sub Totals for each…
-
What formula would I use? IF/MATCH
I am trying to put a formula together to say if there is a date, list it here (On-Site Training), if it says no match, then don't do anything.
-
Can a "checkbox" cell be referenced in a formula?
Can a formula contain a reference to a checkbox cell and then return a result based on if that box is checked or unchecked?
-
Tracking actual time in percentages, reporting in hours?
A component is adamant about tracking their actual time on projects based on percentage of an 8-hour workday, but senior managers want to see actuals based on hours. Is there a formula or other way for staff to enter a percentage and convert that to hours for reporting purposes?
-
Using IFERROR to reference 2 sheets
Using the formula below to pull references from two sheets. I am getting data returned from the first sheet, but not the second. When I reverse the order of the references the formula works the other way around. Do I have an extra bracket or something causing it not to index past the first sheet? =IFERROR(INDEX({Milestone…
-
Combining Formulas - Average, Collect, Combine, Value, IF Error
Hello, I need help with a formula combing average, value, collect, and contains. I am trying to pull data from another sheet pulling out just the values from the selected options (options are 4 - Complete Success, 3 - Success with Minor Risk, 2 - Success with Major Risk and 1 - Process Breakdown) and then to average them…
-
Subtraction Formula
Hi folks, I have a Debt total in a cell on my budget spreadsheet (e.g. 7000); I have a row of payments by month (e.g. 160). I want to subtract each new cell of payment of 160 from the total cell of 7000. I want to visibly see the reduction on the 7000 debt cell when each new month of payment is added. Is there a formula…
-
Need help - adding less than or equal value to a current formula
Hello, Currently I'm struggling to add <= value to my current formula code, my idea is to count for Order Numbers (Unique values) and Lines of Order Numbers of certain times. since filter doesn't work in this code, I'd like to add a <= or >= value formula for Ship_Time, so my code filters can automatically generate…