-
COUNTIFS with multiple criteria in same range and different ranges
@Paul Newcome, would you be able to help me with a COUNTIFS formula that contains multiple criteria within the same range and within different ranges? This count works with multiple criteria and multiple ranges, but now I need to add another criterion ("insect") within the same Metrics Range 3. =COUNTIFS({Metrics Range 3},…
-
Salesforce Imports Apostrophes
This is a public service announcement... If you have an Index/Match that isn't working, and the source sheet is a data mesh or data shuttle from Salesforce, check the numeric field to make sure there isn't a leading apostrophe. The apostrophe will not appear until you click in the cell. You can rid of it with a helper…
-
How do I change when my Sheet starts the next workday?
I have a formula in Sheet Summary that counts workdays remaining until launch. It works except that the count doesn't go down each day until 10 AM. If anyone looks at it before 10 AM, it shows an extra day. I can't figure out why it updates at 10 AM, so I don't know how to fix it. Ideally, it would change at midnight.
-
Duplicates in Column
I used the formula below in my sheet and it seems to be working alright except that it's coming back with a couple saying they're duplicates but when I use control find to see if that eID is a duplicate on my sheet, it's the only one. Is there something wrong with my formula? =IF(COUNTIF(eID:eID, eID@row) > 1, 1, 0)
-
INDEX COLLECT - 2 criteria
Not sure why this formula returns #INVALID VALUE =INDEX(COLLECT({SOInfo Qty}, {SOInfo SONo}, SO@row, {SOInfo WTStep}, [WT NO]@row), 1) I'm trying to return the Qty from the reference sheet, SOInfo, if: SONo matches SO@row WTStep matches [WT NO]@row) I get that all may not match and will use the iferror formula, but none of…
-
Not sharing a row in a sheet
When we share a sheet we share everything but we want to be able to keep company conversations from being seen by the clients we are sharing with. Is there a way to share a sheet but not share a row in that sheet?
-
Date Calculations
Hello All, I'm working on creating a Holiday Dashboard, aiming to showcase the count of holidays taken per month, along with details about who took those holidays. Despite my attempts at formulating a solution, I haven't been able to achieve the desired results. I've attached a screenshot of what I've done so far for…
-
Progress Bar Help
We are using the following formula to generate a progress bar, however, if the 'overall' cell is over 50% it automatically shows on the bar as 75% and anything over 75% shows as 100%. Please can anyone help with where we have gone wrong? =IF([Overall %]28 < 0.25, "Empty", IF([Overall %]28 < 0.5, "Quarter", IF([Overall %]28…
-
How to combine multiple rows of data into one row based off of one cell value.
Hello Smartsheet's community! I am back with another question. I have a database that holds the tracking of employee trainings. The training structure is in tiers and after each completed tier they fill out a form. The raw data from this forms looks like this: Depending on an employee's level they will have a differing…
-
Document the value of function / calculated field every day
Hi all, I have 2 sheets: 1) working sheet where all tickets are logged + their status is maintained 2) calculation sheet with fields showing e.g. number of open / closed tickets and so on (calculated by formulas which refer to the working sheet 1). These values are used for dashboards and so on. I wish to automatically…