Formulas and Functions
Stumped by a formula? Ask for help or find examples to see how others use a formula to solve a similar problem.
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},…
-
Help with Design/Nested FormulasIn Formulas and FunctionsSo I need some help with my design or nested formulas..... I have a formula in a column (listed below) which is perfect, except that in a few instances there are exceptions, and I must add up several different $ amounts from a few CLINS on…
-
The dollar sign isn't showing up on my time tracking formIn Formulas and FunctionsI download a time tracking form from smartsheet, but however I have 2 issues. The table for some reason does not have the dollar sign attributed even though i'm using this formula =VLOOKUP(Activity1, $[Task Name]$5:$Activity$10, 2, false)…
-
Creating a widgetIn Formulas and FunctionsHi, I need assistance in creating a widget for a dashboard. So basically I have got a sheet with close to 2000 rows and each of those rows have action owners, due dates, etc. I would like to create a widget that would show when the actions…
-
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:…
-
Combine "Specific People" and "Contact in a Cell" in the the same approval actionIn Formulas and FunctionsWhen requesting an approval, I want to be able to send the decision to "contacts in a cell" and cc a "specific person". It appears I can only choose "Specific People" or "Contacts in a Cell" when det…
-
LIMITING DATE TO CHOOSE FROMIn Formulas and FunctionsMay I know if its possible to only choose a date today and forward? like limiting what dates to choose in your column. And limit the dates like I can only choose the date today and two days after today?
-
Status update based on start/end dateIn Formulas and FunctionsHello, I'm looking to accomplish the following and am hopeful that someone will be able to help support. Thank you in advance. Working with the following columns: Start Date End Date Sale Status Assignee QA Status Scenarios: If a sale…
-
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…
-
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…
