-
How to summarize data from multiple sheets without manually linking each cell?
Hello, I'm working on a project with KPIs that will be entered into ~50 individual sheets. I want to be able to roll-up these KPIs into one summary view, but am running into trouble when I pull them into a report because I can't perform calculations in a report. One KPI is Overtime %, so I can't just take the average of…
-
Countif containing specific text
Hello! I am trying to count to see how often a specific word, in this case a person's name, appears in a range of text. I've looked over similar questions and have started a formula, but I end up with an #INVALID OPERATION error. My formula is =COUNTIF({January Range}, FIND("Cassie", @cell, > 0)) I've also tried…
-
Tracking percentage on a chart overtime
Hello! I am trying to figure out how to create a line chart that shows the updated % every time it is recorded. I know how to change the percentage complete by using formulas, but this percent is an actual percentage of a recorded number. Not a progression percentage. Is there a way for me to do this so I don't have to…
-
Why cant I count in this date range?
Im tying to count the amount of RLO's between the dates below and am not sure why its an #incorrectargument ? =COUNTIF([RLO Receive Date]:[RLO Receive Date], >= DATE(2024,01,01) <= DATE( 2024,4,1))) Anyone help me with the syntax here?
-
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…
-
Why cant I count in this date range?
Im tying to count the amount of RLO's between the dates below and am not sure why its an #incorrectargument ? =COUNTIF([RLO Receive Date]:[RLO Receive Date], >= DATE(2024,01,01) <= DATE( 2024,4,1))) Anyone help me with the syntax here?
-
Can Requested Data be Compared Against Product Available Data
I have a situation where a form request for products populates a sheet but the products requested may not be available in that market so the request is an invalid one. It would be great if, after form submission, we could compare the new row (request) against a matrix sheet of available products. Has anyone done that…
-
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 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…
