-
Automate Index / Match forumla - add an IF statement? or another Match??
Hi, I have a report that I will be data dumping into monthly (1st pic called "Jan GSS"). I created an Index/Match formula (in second pic) to pull those numbers over into my main sheet (GSS ITRec column): =INDEX({Jan GSS ITR}, MATCH(Marsha@row, {Jan GSS MARSHA}, 0)) How can I make this formula better so that when I add the…
-
COUNTIF for dates equal to current month or current week
I'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}, =WEEKNUMBER(TODAY())) I've also tried using SUMIF instead of COUNTIF. All return "0"…
-
Help with Design/Nested Formulas
So 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 one particular row and multiply it by different %. CAF DUE COLUMN:…
-
The dollar sign isn't showing up on my time tracking form
I 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) * Hours1 I would like for each form entry to start below the previous entry instead…
-
Creating a widget
Hi, 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 are due and who the action owners are (action owners vs due date). Can anyone…
-
SUMIFS with criterion referencing 2 date cells
Dear 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:' 'Andi Hawes Timesheet Range 2' as the range i want to sum up in a nother sheet Andi…
-
Combine "Specific People" and "Contact in a Cell" in the the same approval action
When 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 determining the action from that approval. I have to create a separate workflow based on the population of the approval column.…
-
Status update based on start/end date
Hello, 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 is live and has not yet come to an end date based on start date/end date columns, the…
-
Calendar Header
Hello 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 would like to show regular hours when each location is not on holiday. Ideally i would…
-
COUNTIFS with Cross-sheet references
I'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 next to status called 'Concluded' to evaluate whether or not the ticket's current…
