-
How to show time delays on a Gantt Chart?
We are a construction company using Smartsheet to follow the progress of the construction on site. Sometimes delays occur due to weather, power, etc.. but not all trades are affected. We need to be able to visually show to the clients (via a Gantt Chart) the reason (weather, power,etc..), the length of time (Start Date,…
-
Pen/tablet devices for writing entries into smartsheet
Has anyone used pen/notepad based devices for making entries into smartsheet? We work in site construction and maintenance projects and it would be great for supervisors to walk around, enter actions into a tasks list, or responses to a checklist in the same way they do with a paper pad and pen now. Most will still use…
-
Short Interval Schedule
I am having some troubles making something like this in Smartsheet. It shows manpower throughout a project. Any Ideas how to structure a Smartsheet that would make it easy for the eyes? Gantt chart could be nice but how would i show the change is strength based on time? Thank you.
-
Stumped with a simple formula - countif with sheet reference
I feel silly, but I'm stumped. I'm trying to do a countif with a sheet reference. I want to count how many rows in my Lease Tracker 2018 sheet have Agricultural in the Category column, but I keep getting #UNPARSEABLE. What am I doing wrong? =COUNTIF({Lease Tracker 2018 Category}:{Lease Tracker 2018…
-
Conditions / Rule formula set-up
I am working on a sheet, and I am very new to this application, where I am tracking P.O.'s, date ordered, date received, etc... and I have 2 columns (at the far right of my sheet or end) that I would like to If the P.O. Total is < or = to the Invoiced Amount the cell would turn green and if it was > than to turn the cell…
-
Active Faces
Hello, I am a new User to Smartsheet however after sharing a sheet with a number of people I am finding that the "Active Faces" icons associated with a shared user accessing the same sheet at the same time are not showing on my screen (next to the "Share" icon). I am also finding that the pop up messages (not the…
-
if - and formulas auto populating checkbox
I've created a column titled "Outstanding Approvals", I would like the column to auto populate the check box when "Approval Status" is empty AND when "Start Date" has already begun. I'm using it so I can pull multiple sheets into a single report - but not all the sheets have the same layout. Any help is great! thanks in…
-
Can you import a list of values into a drop down list?
For example, I have a building with over a hundred rooms, I want to load all the rooms into the drop down for a 'Room' column field so it can be choosen from the list using a mobile device.
-
Printing A Sight - printing so small that you cannot read data
Looking for some advice on printing a fairly large Sight. I have had no issues with printing Sights that aren't much larger than what fits on your screen. Push print and that's about it. But - when I tried to print a Sight that was much larger (scrolls down several times in order to see all of the data), it would not scale…
-
PROJECT SCHEDULE TRACKING ON SMARTSHEET
HI I am looking for best practice to project tracking in smartsheet. I tried doing tracking of a project schedule both in MS PROJECT and Smartsheet but i get different % complete . Also i do not get overall project timelines properly matched. Where could i be going wrong?
