-
Count of entries in the last 24 hours
Hello, I've got a sheet to record our queries as they come in and I'm looking for a formula to count the number of entries received in the last 24 hours as a running total I can monitor. At the minute I have set it up to count the queries received yesterday as per formula below but I'd be glad of some help how I can amend…
-
Find and Replace to edit references
Hi! I am trying to edit the three cross-sheet references in all the columns from the master sheet of 2018 to master sheet of 2019. Since I need to repeat it for almost 1200 cells. Is there a way to bulk edit like Find and Replace or something else? Even for selected cells will make it so much easier! the original is :…
-
Index/Match Leaving Blanks + "#NO MATCH"
I apologize if this posts twice... I am a relatively new Smartsheet-er experimenting with the capabilities of the Index/Match function. I have two sheets, one that tracks project status, and one that I would like to link to the first, showing live project status updates by matching the ID # columns. I have created a…
-
Count multiple criteria
I'm looking for a formula to count a single criteria from one cross sheet column and multiple criteria from another column. Any suggestions? =COUNTIFS({My Sheet - Status}, "New Request"), {My Sheet - Unit}, OR(@cell = "Library", @cell = "MGEN", @cell="NuRes", @cell="OARS", @cell="ODEI", @cell="OTP", @cell="Registrar",…
-
Retention Rate and Tenure Rate for employees for current year
I am needing help. I want to create a dashboard to see the current years tenure rate and retention rate by tracking month to month. I have a column for retention status (active vs terminated rate), active status count. Termination month, termination year, termination date, hire date. I have a formula for total employee…
-
Reference flag from one sheet in another
thank you in advance. how do you write a formula that looks at another sheet for a condition present in one column and then look at another column in that sheet to see if it has a flag? appreciate you!
-
SUM(COLLECT/SUMIFS( based on multi-select
Hi everyone, Does anyone have a formula already handy that does this? Looking to SUMIFS values where the variable is one of the options in the dropdown value? This is a cross sheet formula pulling from a table where there is only one country per cell, but looking to aggregate (show me everything in this region).
-
Filtering a report by Calendar Month and sending report
Hello, I have a report that I would like filtering by calendar month showcasing data just for that month. I can only seem to filter the report by 'last 'x' amount of days'. Seeing as though months vary in days, the report it could show additional data not required. I had then created some helper columns on the underlying…
-
I want my formula to count the blank cells in another sheet and also by a particular status
=COUNTIF(AND(NOT(ISBLANK({My sheet - Unit}),{My sheet - Status}, "New Request")))
-
Vlookup Date into another Date field - #DATE EXPECTED Error
Hello, I am using a VLOOKUP to pull a date into a sheet from another sheet. Both columns (date source / range, and destination column) are Date column types, but the destination sheet is returning the # DATE EXPECTED error. I thought if you were pulling a date from a date column, into another date column, the return value…