-
RTF in Dashboard Widget
I downloaded an example dashboard which tracked multiple projects. Looked good and decided to build my dashboard to match example. Example dashboard has a Rich Text Widget which has multiple formats within. However when I try to use the rich text widget it does not allow me to have varied formats (different text sizes,…
-
How to put in exact dates when tasks have predecessors linked
I have all my tasks linked to predecessors so that dates adjust correctly, but I am now unable to change the date to something farther down the line unless I unlink everything. Does anyone have an idea of how to fix that? Thanks
-
Adding months automatically
Hi all I am trying to automatically add a 6 month review date to a start date, it is working fine until a start date is past June, to which I get a #invalid value error. The formula I am using is: =DATE(YEAR(A2),MONTH(A2)+6,DAY(A2)) So 1/6/19 becomes 1/12/19 but if I try with 1/7/19 I get #invalid value instead of 1/1/20.…
-
Project Schedule/Milestone Tracking Solutions
Hi Everyone! Does anyone have a project schedule/milestone tracking solution to share? I'm trying to create a company wide solution to input/track schedules for multiple projects, multiple milestones within each project, and provide executive level visibility of the status of each project. Any good ideas would be…
-
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…
-
First time at ENGAGE 2022 and loving it!
This is my second here at #Engage2022 in Seattle, WA. and I feel amazing! What an wonderful experience to be attending to. I really happy to be surrounded by a diverse and enthusiastic group of peers, this is a great example of how in-person events were something that we were all missing. Sharing insights, knowledge,…
-
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"…
-
Automatic Children Indenting
Hello, Is it possible to set up a formula for information (if it is the exact same as the parent/child row above) that you have underneath a child/parent row to automatically attach itself inside the Parent/Child Hierarchy? I would rather not have to manually go in and Indent new info from information dumps, as there will…
-
Can you group columns?
I have a very large Smartsheet that contains contact info, partners, dates for various deliverables, financials, etc. I'm wondering if there is a way to group columns that reference similar tasks thereby make moving around the sheet a little more efficient? For example there are 14 columns that pertain to permitting, 5…
-
Construction Bid Comparison Solution
Does anyone out there have a tried and true construction bid comparison solution they'd be willing to share? Looking to make automation from Bid Tracking/Comparison/Scope Coverage to Contracting and having trouble going from our current solution which is column based, to a smartsheet format which is row based. screenshot…
