-
My - Smartsheet Wish List 1 Automatically update Column names in reports when changed
Hi, When you change the name of a column in a sheet it will adjust the formulae no problem, however it does not update them in any reports being run from the sheet. Please can this be looked at as it is extremly time consumming going through all your reports just to delete a column that is wrongly named and have to re…
-
Showing Only the Parent Rows in a Dashboard Chart
Hi - I have created a dashboard to show pie charts of my data. My problem is that the pie chart wants to include every single row as a data point, I only want to show the parent rows and not the children. I used the formula "=Count(Ancestors(row))". This gives me a 0,1,or 2 based on how many ancestors the row has. But I'm…
-
Formula takes a few seconds to populate after the sheet is opened
What could be the root cause for a formula not populating until a few seconds after opening a worksheet? I built a formula off of a contact cell that references a roster to show an individuals manager but unlike all the other formulas in the sheet, this one takes a few seconds to calculate, it is throwing off my reports as…
-
How to count how many users assigned to in a sheet
Hello, I have multiple projects and each project is in its own sheet. I am trying to create a summary sheet (to later show in the dashboard) that shows how many people are assigned to each project currently. Is there a formula for this or a feature? Thanks
-
Report Building Criteria
I am trying to build reports that segment my data into 5 different reports. One for each year 2019, 2020, 2021, 2022, and 2023. When I select the GLY (Go Live Year) with any on the aforementioned years, my reports come back blank. However, when I select a different criteria and then add the GLY as an additional column, the…
-
Formula to count fields that are not blank
I am just getting familiar with smartsheets and am having a problem convert a spreadsheet that contains a formula that I really need. This formula currently works well in Excel to count cells that contain dates so if any cells are blank it won't count the cell. This is the formula that works in Excel…
-
Isolating Reports & Linking from sheet to sheet
We have a data base of Subcontractors, that is created in a sheet. I am trying to have a tracking sheet (Bid/Contract Request) from bidding to contracts per job and per subcontractor. I have a column of subs that I have linked from the data base and then a column (checkbox) per job. Then the superintendents will go to this…
-
Reports pulling from formulas
I have reports calculating off multiple workflow sheets based on a column in the worksheet with formulas - the reports sometimes appear blank and when I go into the worksheet to see why, the formula column shows as blank and then reappears - almost like they only recalculate when looking at the sheet. the fomula is a…
-
Formula Help: Count "To Do" for rows with start date in June
I am currently using this function =COUNTIF(Status:Status, "To Do") to identify the total number of tasks with the status of "To Do". I'd now like to break this out to count the total number of "to do" that start in June for example. How can I add this additional ask for the date? Thanks!
-
Report not including today's date results
Hello, I am trying to get a report where I don't need any information that falls prior to 7 days from today so I have that option selected on the "When" but the problem is that the report is not showing today's results at this point. Any idea how I can automate this? I chose to add another criteria where the date also is…