-
Copy To Another Sheet
Please help! I was curious if there is a formula that would copy a row to another sheet, only if a certain column meets the criteria. I created two sheets that are exactly the same, but one is named Overtime and the other is Branch Visit. If the Branch Visit column states 'yes' on the Overtime sheet, can that entire row…
-
Next deliverable date based on TODAY
Hi Many thanks in advance to start! For each row i have a listed task with a column called Period 1 with a date and a checkbox next to it than when checked marks the date green. Each date represents when that task is next due. Extrapolate that out across the row and i have many dates for every interval the day is due, ie…
-
Must start / must end date restrictions
Dear community I'm a Project Manager in the field of business administration. I'm a former MsProject user. I'm very happy using Smart Sheet. It's great and I would recommend to use it. However as Project Manager for projects within the administration environment I do have a desperate need Smart Sheet does not cover. It…
-
Auto Populate second sheet
Hi, I have a main sheet with a form. As you know, every time a user submits a form, a new row appears. I was wondering if there is any way to have a separate sheet that connects to the main sheet so when a new entry is added through the form on the main sheet, a column is updated on the second sheet reflecting the new…
-
Prevent a milestone from moving, regardless of predecessors? (flexible lag time)
I have a milestone date in my timeline (0 day duration). I would like to link it to a predecessor that is currently scheduled to finish a few days before the milestone, however, when I add the predecessor (Finish-to-Start), it moves my milestone date! (Moves my milestone date earlier, to occur the day after my predecessor…
-
Sheet content, shifting rows
Oh boy I have a good one today. Please Help! On Friday I was working on my data base sheet, linking cells in a couple different columns to another sheet. (I hid the columns in between, to make it easier). Today, I noticed that the columns in between have shifted down a few and the further I get down them worst it gets…
-
Trigger notifications based on dates previously input
Hi all, Trying to build 2 spreadsheets that need to communicate with each other at this level: One of them (first) will have the raw material code, name, supplier, last date of testing, risk rating, test required, etc. The other (second) spreadsheet will be a record of materials booked in. Will it be possible that, by…
-
Setting date in Project profile data from Master intake form
Am I missing something? I've been trying to push the start date of a project from the intake sheet (via intake form date input field) without success. Upon spinning up the project in SCC, I get the error: * Failed to update template field(s) for "Project Profile Data" (Code: 5536 - Message: The value "04-27-2018" could not…
-
Ancestor/Child Blueprints
Very curious about this Ancestor (aka parent) and Child Blueprints under one Program.. - I think it would really help our Program, as we need to work off of a "master" project number list which can't have overlapping numbers. I'm sure someone's dealt with this in other ways.. but not certain how. Did you have one intake…
-
Isolating Reports & Linking from sheet to sheet
We have a data base of Subcontractors, that is created in a sheet. I am trying to have a tracking sheet (Bid/Contract Request) from bidding to contracts per job and per subcontractor. I have a column of subs that I have linked from the data base and then a column (checkbox) per job. Then the superintendents will go to this…