-
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…
-
Automatically uncheck column based on date TODAY()
How can I get columns unchecked automatically when they meet a date criterion? For example, all tasks checked today will be automatically unchecked tomorrow because the calendar date has changed.
-
Using COUNTIF on a Range with Cross-Sheet References
I am attempting to use a COUNTIF formula on a column of cells that have VLOOKUP formulas pulling in information from another sheet. The COUNTIF formula returns a #NO MATCH. When I copy/paste the VLOOKUP info into text only, the COUNTIF formula works but this destroys the advantage of using a VLOOKUP formula in the first…
-
E-mail notifications
Hi, I have a 'Sheet' named 'Main sheet' with forms submissions arriving all the time, within the 'Main sheet' there is a field called 'Employee Department', when populated from the form this looks up the 'Project Sponsor' from a further 'Sheet' named 'Lookup' and pulls the e-mail through to the 'Main sheet' - this all…