エンタープライズ向けに構築

Migration to a new employee

I was able to transfer all owned data from a former employee to a new licensed employee. ... However, all the notifications that are set up in automations on individual sheets still have the former...

Automating Reports to Pick Up New Projects

11/03/21 in Smartsheet Basics ... When we have a manager assigned to a project in our project intake sheet I would like our portfolio reports to add those new projects automatically. ... Project ID...

How to display "closest matching" rows based on an "input" row?

Hello all! ... I've been building out what is essentially a database to track information related to customer orders of a specific product. ... The product is essentially custom tailored firmware -...

Various errors when rolling out dashboard updates

07/12/22 edited 07/12/22 in Smartsheet Basics ... Hello- we are trying to update all of our dashboards and are receiving the following errors: ... Chart widget 'Number of Tasks': Multiple Rows foun...

Is there a solution or workaround for importing excel sheets every time content changes?

Home› Get Help› Smartsheet Basics ... Is there a solution or workaround for importing excel sheets every time content changes? ... Cameron Ostafin ✭✭ ... Currently our client submits an excel sheet...

Conditional Formatting

I am trying to use conditional formatting to format a cell based on if the contents of the cell is greater than the contents of another cell in the same row. ... For Example if one column has expen...

SUMIF not adding correctly

If I copy the formula to all the rows in the Total Used column, all results are "0". ... I would suggest adding in an entirely new Helper Column for the VALUE function as a totally separate formula:

Copy column from one sheet to other sheet

I have a master sheet with the event name, date, location etc. that when a row is added to master sheet I just need the name and dates of event to be imported to new sheet (Event Shipping Manifest).

Exported Data does not match data shown in Report

I have a Report in Smartsheet that pulls data from multiple sheets. ... When I run the report, all data populates accordingly. ... However, when I export the data to Excel, the data from the Primar...

Trying to create a Request System for 5 departments

I am currently using the Request Management Template set and I have questions and would HAPPILY accept all assistance! ... I need a dashboard for the overall office that has links to 5 other dashbo...

Add Optional Sheets to a project that's already provisioned in Smartsheet

I provisioned a project in control center. ... I left out some optional sheets. ... Now, a week later, I see that I want those optional sheets. ... Is there a way to add them to my project without ...

Document Builder - Error when attaching to Row.

10/27/21 in Smartsheet Basics ... I've set up a system where we use the Document builder to create a PDF report with some text and photos for customers. ... It seemed to work well, however it's bee...

Frequently Disconnected/Logged Out

I've taken this up with support but in the meantime (several days and counting). ... About a week ago or so I noticed that as I go about my day to day work, pretty much exclusively in Smartsheet an...

Report Sharing

I would like to share a tasks report to my team every week. ... The goal is to have one sheet with the 'assigned to' filter on so that whomever is reviewing the report sees their tasks only. ... Th...