-
Charts
I would love to see Charts being used with categorical data instead of just numerical data. The count function is critical to what our clients want to see. Also, it would be awesome if we could embed the charts we create into the Dashboards instead of just providing a link to the chart.
-
Resource Allocation in Parent Rows
Does Smartsheet allow resource loading parent rows? I am trying to assign parent rows to staff and allocate percentage on the parent row, but it does not allow allocation entry on the parent row. I do have resources enabled on the sheet. I do not want the parent row to sum the allocation percentage of the child rows.…
-
"Dashboards just got better"
Has anyone had any success creating a chart with nonadjacent columns following the recent communication that the charts have more options?
-
Checklist Summary Reports
Id like to summarize status for a list of users involved on multiple project checklist. The dashboard function tells me I can only use numerical data in reports/widgets. Is there something I am missing? I want to provide a quick glance at overall status of multiple checklists.
-
Is there a way to have the rows automatically sort ascending by date when new rows are entered?
I have a job board created that jobs are added to and dispatched from the problem is if the jobs are not ented in order by date then I have to manually sort each time. This is a 24/7 process mostly accessed by mobile devices so sort is not an option.
-
Filters for different users
hi Im a new smartsheet user and need some help! we have a sheet with a work schedule. There are address/information columns and then columns of dates for various contractors. We would like to give view only access to subcontractors but only want them to see their own columns. We want them to be able to access this…
-
How to change row formatting based on a single cell?
I am trying to create a list of design standards and have a drop down list in a column that associates each row to a different project type: Affordable, Market, Selling. I'd like to be able to have the first row be a control that sets criteria for the rest of the sheet or a specific column. Thus if I select "affordable" in…
-
Calendar View
My conditioning format does not show when I view my smart sheet in the "calendar view". Any suggestions?
-
Automating RGYB Balls With Date Ranges
I want the status balls to automatically update based on the due date - but I also want the status to go blue after the "Item Completed" column is checked. Ie. If End Date is in the past, or due within the next week = Red If End Date is Due within the two weeks = Yellow If end Date is Due in three weeks or more = Green If…
-
This rule triggered itself directly or by at least 1 other rule, which is prevented.
I have a SmartSheet constructed as follows: 1. A dropdown list contains five options to indicate the task status (Column = "Pickup Status"). Pickup Status Pending... Pickup Now Do NOT Pickup Pickup Completed Unable to Pickup 2 . The Foreman will use a form to submit the initial data and set a hidden field to "Pickup Status…
