-
ABSOLUTE CELL LINKING
Im really struggling with getting an absolute cell value to stay in a sheet or in a sheet summary. maybe im going at in the wrong direction. please help. I have a form on my call centre data sheet that is adding an information line each day. The line is picking up all my formulas for my metrics on who is answering the…
-
sort in report
i have a repotr based on sheet with ~1500 rows (parents and children). as i know there is no way to show the parent and children in repost so that i mark in color the parent and sort the report to show the parent and children. but, now i want to sort with another level: i want to show in report the parents row and…
-
count tasks per week number
Hi community, I'm trying to count the tasks in my gannt per each week in a separate grid. Then i'll make a graph representing work overloads throughout the year. Here is my formula that calculate 0 every time (at least not an error) : =COUNTIF({6530 - Sulfuric project Schedule Range 5}, WEEKNUMBER({6530 - Sulfuric project…
-
Creating an Age Pending report
I am fairly new to Smartsheet and trying to create an age pending report. I have used the =IF(Submitted By = 1, 0, (Created1 - TODAY())), and receiving an error message. Could someone assist me with this please?
-
How to display source sheet row number in a report?
In the available columns to display in a report, there is no option to show the row number of the record from the source sheet. Is there any alternative way to accomplish this? If not, can Smartsheet team please add this to the feature enhancements? Use case: I am displaying several tasks from a project plan that are…
-
How to add multiple values when creating a chart/graph?
How I can pull data from a cell with multiple values to create charts/graphs? Currently, the graph only shows/captures single value from the cell and not the other one. Is there a way around how to get this done? For example, when i am trying to build a bar graph for the values under "Hiring Manager" on row 5 -the second…
-
Auto number
I have a spreadsheet where i keep track of all the samples that we've sent for laboratory testing. They all have a despatch date and the lab that they are being sent to. Is it possible to set up the Auto-number system to generate only one number for all the rows with the same lab and date? The goal for this is to create…
-
Rollup summary of data
This is probably a very simple formula required but I am struggling with it. Can somebody please assist? We have a number of clients on one sheet where we track different trades budget vs. actual for each client. e.g. Plumbing, Electrical, Carpentry etc. We want to count up all the budgets for the Plumbing for all clients…
-
How can I remove a sheet reference, so I do not receive the alert ‘Reference a total of 25000 cells
Background: An International source Smartsheet has 1700 rows (and counting) and 85 columns. Using the Index/Match formula, we reference 14 columns of data within a new Regional Smartsheet. Why? Regions want to add additional Country-focused data, data that should not be managed on an International sheet that already has 85…
-
Track time an item was open (active)
I have a date stamp column already in the SmartSheet. When a new row is added, a date and time are assigned. What would be the best method of tracking and reporting the time duration between when the row was added and when it was closed ? I have ideas but have found it makes most sense to run it by one of you first.…
