-
Enhancing Workflow Management on Consulting Projects
Hello! I need some help enhancing how we track our current projects in Smartsheet. I work for an engineering consulting firm. We have been using Smartsheet over the last 9 months to track tasks and manage workflow. The majority of our projects are labor-only. Due to the nature of our work with public agencies and…
-
Project Dashboard Generator
I am trying to develop a dashboard generator so that I don't have to recreate every report I use in our dashboards each time we have a new project. I would like to be able to select the project number in one location and have all the reports reference that project number to pull data from their respective sources, then…
-
Smartsheet Merge and Transpose
Hello, I have two sheets. One sheet is a list of items to be offered at a charity auction with a different row for each item and columns with specific (Item number, donor, minimum bid, winning bidder number, cost etc). The 2nd sheet is a list of the bidders with a sum of the total that they have bid (bidder number, count…
-
how to receive excel file notification for the newest update in smartsheet ?
Hello, for the current smartsheet, for each new/update records in smartsheet: we receive an email notification for these updates. that is great.., however, in stead of receiving an email with all the new/update records on that email. are we able the send all the update/new records as an attachment - (excel format) via that…
-
Auto Sort Based on radio buttons
Hi is it possible to move rows and children within the rows to a different sub-category. e.g. we have a purchasing smartsheet which has 3 status icons which are either blank or green for processed for: 1. Ordered 2. Paid 3. Delivered Based on the status of each column i would like to sort the sheet into three categories,…
-
countif column values based on a monthly value
Hi, I am creating a table of count of values in a column based on what month is reported in another. the table I want is attached. The formula I am using is as below. Can anyone advise what need to change in the planned formula =SUMIF{V2.0 Eirabot - Gantt Range 1}},"12", {V2.0 Eirabot - Gantt Range 1} I also want to have…
-
Report Builder: Adding Column in report that does not exist across multiple workspaces
We make use of multiple shared workspaces and users then create a report that shows them all line items that they have been "Assigned To". A user would like to be able then have a column available to her to enter her prioritization to work on the items. For example, she may want to use a number system 1A, 1B, 2A, etc. or…
-
Dashboard and Sheets - Making 0 appear instead of error or formula
Good evening When we are setting up dashbaords and we have not yet enetered data , how do we make that data show a "0" instead of "# Divide By Zero" , it just looks messy.... Thank you
-
Setting up Alerts
We are running a number of different projects on a sheet that have a: 1) - Delivery Deadline (which is specified by the client), 2) - Delivery Date (which is set by dependencies on our Production Schedule) When Production is running late, the Delivery Date can end up later than the deadline. How can we set up an alert to…