-
When the CopySheet API responds, is the copied sheet really fully created?
I am synchronously using the CopySheet API to make a copy of a sheet. This API responds with a sheet summary, which itself includes the copied sheet's id. Immediately when that sheet is copied, I call the GetSheet API to get the full details of the new sheet. Mostly this works, but a moderate number of times, I will get a…
-
Allow editable formatting in automated emails
It would be great if similar to a document generator, we could generate an email template. One example I have attached where it shows "1 row added or updated (shown in yellow)." It would be great if that was an option to enable or disable some of the email elements or have my own format filled out with information in my…
-
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…
