-
Resource view, tasks
Hi, I am trying to configure the resource view in the way it's meant to be used. Currently, I am missing the actual tasks and the way that I need to use it is making me crazy, please help. I have attached an image which describes the issue, is there any way to expand the projects so that you can see the task names as well?…
-
Return Multipe Cells
Hi Smartsheet community, I have the following columns: [Name] (text/number value) [Team] (drop down value) [Budget Milestone] (checkbox) [Program Milestone] (checkbox) [Project Milestone] (checkbox) Now I am unable to run a report because the what in report builder condition is either all 'OR' or all 'AND', not all tasks…
-
Counting using Countifs if a date is present
I'm trying to create a countifs formula where if it finds a date in a column and is a particular county, it'll count that line. I tried this and don't get an error, but it returns a zero which is not correct. Thank you!! =COUNTIFS({McAdvCareSiteReview Range 2}, (ISDATE(true)), {McAdvCareSiteReview Range 1}, "king")
-
What happens when you approach Maximum Rows in Smartsheet?
I know there are many advantages to having many small sheets in Smartsheet rather than one large sheet. However, in some cases, it seems easier to manage to track many small, similar projects on the same sheet. Has anyone had experience with sheets that have a number of rows near or over the Smartsheet maximum of 5,000…
-
Need help getting multiple sheets pulled into a single report in the correct order
I have three "what if" schedules that I'm trying to pull into a single report. They are simply named Scenario 1, Scenario 2, and Scenario 3. No matter what order I select them, the resulting report has #3 in first position, #1 in second, and #2 in last. I did a bulky workaround by adding a Helper Column in each sheet…
-
Count multiple criteria in a row
I have spent hours scrolling through all the great advice in the Community, and there is not a formula that is working for me. I need to count all the Semi-Annual Update, In Progress, and Waiting on County in a column. =COUNTIF([Status Report]:[Status Report], "Semi-Annual Update") works great to count all of the…
-
Horizontal Axis Maximum Range
Does anyone know how to alter the horizontal axis range? I have a chart that is displaying percentages but the horizontal axis maximum percent is set to 120% so pieces of the project are looking as though they are not complete. I tried stretching the chart out and making it smaller, nothing works. In excel you usually have…
-
Percentage of certain cells in a column
Probably it's easier than it looks to me, but I'm very new to Smartsheet and any help is highly appreciated. I have a column that contains name of several cities corresponding to complete projects in another column. I'm struggling to put together a formula that will calculate percentage of each city in the whole list. Any…
-
Feature Request - Comments and Attachments trigger 'modified' column value
I'm trying to create reports that will show my projects the changes to their workspaces over the past day. I thought a report would do the trick, and I'd just filter by modified within the last day. However, reports don't always catch what you're looking for, like ALL the changes. Report WARNING, the "modified" system…
-
Last Modify Date based on Comments
I'm looking to see if there is a way to update the "Last Modified Date" system column when someone adds a comment to a row.
