-
Calculating Count of Projects by PM by Month
Hi, Trying to create formula to calculate How many projects start in a certain month by each Project Manager - My excel formulas are weak Master sheet has columns: Project Manager is Contact List (does this have to be a Text/Number Column?) Project Start Date - is Date type Column =COUNTIFS({Keller Project Summary - MASTER…
-
Feature Request - Cell History Graph
For all of my projects I need to track the overall % complete for the project and individual areas. I currently have Smartsheet calculating this information and displaying as a % in a cell, but I would like to be able to show how the % complete has trended over time. Is there a way to show the individual cell history as a…
-
NETDAYS #INVALID DATE TYPE
I can't figured out why #INVALID DATA TYPE auto fill when I haven't pick a date for the start and finish date. If I do have those fill out then the formula works fine but otherwise it just fill the duration cell with that error. I do have the duration column under Text/Number. The only thing that I can think about is that…
-
Hyperlink to Cell in same Sheet
How do I hyperlink a cell in the same Smartsheet?
-
Forms
I created a smart sheet that notifies the appropriate lead when someone is requesting access to a project. All the formulas, filters, and alerts are correct. The issue I'm having is when a form is filled out a new row is created the formulas aren’t being placed in the appropriate cells so the notifications for leads would…
-
SmartSheet connectivity via ODBC
G'day We are looking at the possibility to migrate our project meeting minutes from Excel to SmartSheet. The Excel-based minutes have columns that pull data from different sources, being Sage and Dovico via ODBC (extracted data is in another tab within the Excel file), is the same possible in SmartSheet? If so, would…
-
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…