-
Is it best to link only one predecessor to each task or is it ok to have multiple?
I am working on a construction schedule and wondering what the best practice is for attaching predecessors. I have noticed my Gantt chart is currently a bit all over the place and I am thinking it is because I have too many predecessors for each task. Do more experienced Smartsheet users recommend only having one…
-
Excited to Implement Work Apps
I’ve learned a lot at the conference, but I’m most excited to implement Work Apps with the teams I work with. A one stop shop of all the necessary information will help improve their efficiency.
-
Very ENGAGING at #Engage2022
Having so much fun and learning all the things at Engage 2022 in Seattle!
-
Help Searching Mutiple Job#
I want to be able to insert in my table the information: PO,Project Description,Customer,Payment Teams,Business Unit,Submitter,Notes from anothe sheet that contains the Job information. From the Job# column, I've done it before with an index match but only when is one project. I want to be able to do it for multiple Job…
-
Total Site % Complete + health
I need the total site % Complete Each milestone has % complete for the site project What is the sample formula to calculate each milestone % complete columns to give the site Total % complete? Let’s say, Milestone ABCDEF etc I just want to SUM all the milestone % complete to give me the total project % complete Then the…
-
TOTAL% COLUMN
-
Linking checkboxes across 2 sheets
I've got 2 spreadsheets for tracking job progress. One is an end of day report filled out by field personnel. The other is a collection of all the information about various jobs gathered from the end of day reports and manually entered data. I want to link a checkbox when any end of day report has a "Install complete"…
-
Indenting Text for Dashboard Exports
Hey Smartsheet Community! I am posting this in response to the Engage Product Vision sessions that Ben Canning hosted, where there was some talk about someday exporting dashboard content other mediums such as PDF, Powerpoint, Google Slides, etc. In my company's change management journey we have been working hard to…
-
Predecessors - creating conditional workflow question
Probably Smartsheet 101 but seeking help nonetheless. I've already selected "Dependencies enabled" in the sheet settings. My goal is to restrict a column checkbox (called "Start [for a task]) from being selected unless the predecessor has been completed (a checkbox column called "Complete"). I'm not certain how to complete…
-
countif with dates
Can anyone tell me what might be wrong with this formula? I'm trying to count the number of items that are complete, as noted by the presence of a date in the date completed field. I need to know the number of fields that have a date in 2018. Thanks =COUNTIF([Date Completed]1:[Date Completed]14, "=>1/1/18")
