-
Formula to track % complete of a fabircation component in a row
Good evening, I will try and explain this without messing up * We are using smartsheet to track fabrication of product * each row is an item we fabricate * each item has a budgeted amount of time per task designated in a column * they are python, fit up , weld, unload, and admin * the sum of alloted time is *…
-
Processing Limitations: List of formulas in order by relative processing power required?
Hey Community! One of my first requests. I dug around and so far haven't found anything, but my apologies in advance if this has been addressed elsewhere. My company has been bouncing off sheet limitations for a bit now, yet none of our sheets are anywhere near 10,000 rows (I separate into logical volumes as often as…
-
New Mobile GPS Location Reporting
Hi Everyone- we just received a notification regarding a new GPS locating feature for Smartsheet, which would be a game changer for us, potentially. Can't seem to find any specific information on it though. Would anyone know where I might find a tutorial or video?
-
Is there a way to use SumIF to add values in a column that match a specific text string in adjacent
We are building estimate sheets using a hierarchy based on Construction Specifications Institute's organizational coding system. I have rows nested using multiple parent / children. The top level is the CSI Division, which has children rows with specific categories within that Division, and each Category line has nested…
-
Difficulty Printing
Im a little miffed at the amount of discussion on this topic, dating back years... and Smartsheet has not fixed the problem. I am not a Tech guy, but whatever the reason is, just make it easier!!! Its way too complicated to print a sheet onto one sheet of paper and keep it scaled right. is there not some programming…
-
SUMIFS - Contains value in cell from another sheet
Hi All, I want to create a "Total Vendor Paid Amount" column on our "Main Dashboard". This column will need a formula that pulls information from another dashboard called "REO Vendor Invoicing (3)". I want the formula to sum the total invoices paid, in the "REO Vendor Invoicing (3)" dashboard, of jobs that contain a cell…
-
Dependencies on GANTT view
Hi, I am struggling to get sub tasks report as I think they should. Example in screenshot. Basically, if I have sub tasks, then I want to have the heading task report the last date when ALL the tasks are complete. At the moment, by default, the main task shows when ANY date is entered in "Finish" which if sub tasks are…
-
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…
-
Roster
Good afternoon. I have been tasked with creating a roster within Smartsheet. Please see below a screenshot of the current roster we use in excel. I work for a construction company that have teams working on different construction projects. Some projects can last months, some only days. I have looked at the templates for…
