Formulas and Functions
Archives for January 2020
Discussion List
-
COUNTIF for dates equal to current month or current weekIn Formulas and FunctionsI'm attempting to create a metric that counts the number of installs in the current month (and also another for those in the current week). I have tried the following: =COUNTIF({Master Range 1}, =MONTH(TODAY())) =COUNTIF({Master Range 1},…Answered - Pending Review 1K views 11 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
How to count number of cells in a rangeIn Formulas and FunctionsHello, I have two questions about counting the number of cells in a range? How do I count all cells in a range, whether or not they have a value in them? COUNTM seems to exclude blanks. Can I do they same for a list that is not a range? T…
-
Calendar HeaderIn Formulas and FunctionsHello there, I am trying to create a calendar view that shows holidays for 4 different locations around the globe. I've populated the grid with all of the holidays for each location and they are showing just fine on the calendar. But i w…Answered - Pending Review 11 views 3 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
Project Management: Automating Timelines Across Multiple Projects/SheetsIn Formulas and FunctionsBefore I go into specifics, maybe the simplest form of my question is: can I somehow mimic the functionality of LiquidPlanner's "Smart Schedules" in Smartsheet? (Just to clarify, my company doesn't have LiquidPlanner nor does it …Answered - Pending Review 510 views 2 comments 0 points Most recent by Robert Cybulski Formulas and Functions
-
COUNTIFS with Cross-sheet referencesIn Formulas and FunctionsI'm trying to get a count of rows between two dates AND where we have the status as one of three choices. I've tried using the OR logic embedded in the COUNTIFS formula, but I couldn't get that working. Instead, I created a helper column n…Answered - Pending Review 51 views 1 comment 0 points Most recent by [email protected] Formulas and Functions
-
Returning Max Date from Another Sheet with ConditionsIn Formulas and FunctionsHello, I am trying to gather the max date from a row on another sheet if that row has a matching cell to one on the current sheet. Below is a screenshot of the current sheet. I am trying to fill the Last Action Date cell if the Originating…
-
SUMIFS with multiple criteria in multiple columnsIn Formulas and FunctionsHi - I'm trying to create a formula that will sum the amount of hours in one column when it meets a certain criteria (type of hours) from another column, but only if they were accrued after a certain date (a third column). No matter what I…
-
SUMIFS with criterion referencing 2 date cellsIn Formulas and FunctionsDear Forum, i would like a SUMIFS formula to be able to count hours in my timesheet on certain dates. All my hours and dates sit in one sheet, id like a second sheet to then count hours in certain dates. As i understand it, SUMIFS needs:…Answered - Pending Review 21 views 1 comment 0 points Most recent by Genevieve P Formulas and Functions
-
Conditionally changing cellsIn Formulas and FunctionsHi, I'm looking to see if there is any formula(or anything else) I could use to change a cell to a specific pre-defined value, if a different cell is CHANGED TO a certain value. I know that the changed to functionality is available through…Answered - Pending Review 101 views 10 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
Turning symbols into a percentageIn Formulas and FunctionsI have a parent row where I would like to show the % of ticked answers for all the children rows . I can see that the tick is formatted as 'YES' but i can not work out the formula to change the yes into a number to get the %?
