-
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…
-
Importing Google Finance Data into Smartsheet?
Hi all, I'm attempting to pull Google Finance Data for monitoring stock price movements and creating charts for projected outcomes, etc. I'm not sure if Google Finance data is natively supported or not. I did attempt to import an existing Google Sheets spreadsheet with some formulas in it but receive an "#UNPARSEABLE"…