-
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…
-
Conditional Formatting not applying consistently
I have a sheet with conditional formatting rules so that if there is a "0" in a cell the text will be gray and if there is a negative number it will be red. If I close the sheet and then open it again the conditional formatting does not show, but if I go into the setting and basically pretend to change the formatting it…
-
Notification When a Date Changes
I am trying to work with formulas and notifications so that if a person does not change a date in a cell, then they are sent an email reminder. Once they change the date in the cell, they won't be sent the reminder. In the picture above, somebody will manually enter the Due Diligence Date. The Site Development and Hard…
