-
Column Formulas Display Forms
We have a Control Center solution and forms that are tied to RAID logs and more. We have no way on a FORM to automate a project name or ID We would love (like on Card View) for a Column Formula to show static information on the form that pulls from the sheet. OR the option to pull Sheet summary data to the form. This would…
-
Smartsheet Summary Counting Assigned to with multiple people in the field.
I have the sheet below and I want to count for each person how may items are pending their approval. The formulas I have tried only find where it is only one person in the column. Where there are two people in the column it ignores the column. I have tried =COUNTIFS([Pending Approval From]:[Pending Approval From],…
-
Create Formula in Sheet Summary field to pull only Month from another Sheet Summary Date Field
I have a date field for projected go live date for projects in my Sheet Summary. I would like to add another field with a formula that will display only the Month Name in another field so that when I run the Sheet Summary report I can summarize projects going live by month. I would appreciate any guidance!! Thank you!
-
Modern Reporting now available on Smartsheet Gov!
Hi Community, We’re excited to announce an improved, more intuitive way to create and update reports is coming to Smartsheet Gov. The new report builder makes it easier to understand, create, and update reports with an improved, more intuitive experience. Card view gives you quick and actionable insight into the status of…
-
All up view of construction projects
New to smart sheet and construction projects being managed here. I'm building a template library and hoping to have a consolidated all up view to how they are progressing. Where is the best area I can research this, understand it more clearly? Is there a team where I can simply have one on ones with super users?
-
How can I group a Contact List column from a source sheet in a Report?
I'm currently working on a report and trying to Group and or Summarise a column that is a Contact List from the source sheet, but finding that I can't do this. I want to be able to run a report that groups projects by team member. I've searched Smartsheet Community and Google for answers, and looks like it's not possible.…
-
How to get a formula to count only negatives or only positives
I have two formulas for a helper column to a metrics sheet. I made a column that counts the number of days until an order is due to arrive, and then there are two helper columns. the first needs to take those numbers and return a value based on the number. So if the order is set to arrive in 5 days, then the value would be…
-
Formula to Count Ages of Orders
I'm trying to create a formula that counts the open orders based on the date the order was created. The thing complicating the formula is that it's for a metrics dashboard, so I need it to count the orders that are between 1-3 months old, 3-6 months old, 6-9 months old, 9-12 months old and over a year. I'm at a complete…
-
Rolling up counts from several sheets to a dashboard
I have 6 projects. Each has a risk register on a separate sheet Each risk has one of 5 possible statuses each of which has a color, (Blue, red, green…). Each risk also has a Probability/Impact score, grouped by 5s, 1-25 I have created 10 sheet summary fields on each sheet to count these. I have created a sheet summary…
-
Ability to add Sheet Summary Reports to Dynamic Scoping on Control Center
This functionality is available for "Row" reports, but "Summary" reports really should be included. Many clients use sheet summary to keep grids clean and lean; but, if we can't leverage dynamic scoping for those type of reports, it weakens the case for Control Center. It's either we bulk sheets up with columns to fully…
