-
Auto Fill Dates
I am trying to have cell automatically fill the following dates: * First day of the current week (i.e Monday) * Last day of the current week (i.e Sunday) * * First day of the next week (i.e Monday) * Last day of the next week (i.e Sunday) * * First day of the previous week (i.e Monday) * Last day of the previous week (i.e…
-
Schedule Duration Issues
I've been working in a CPM schedule. The original showed a 141 day duration, starting 12/12 and ending 05/04. I'm updating some of the relationships as I had to rearrange the work pattern a bit, now my schedule shows 144 days, starting 12/12 and ending 6/29. Does anyone have an answer as to how I gained only 3 days…
-
find deleated items
I am looking for a way to track items logged on a web form or a way to find if a line item has been deleted
-
Excel Compatible Symbols
Hi there, I am creating a sheet for a project that I will need to export to Excel for poeple outside of my company to use and I was wondering if there are any symbols that are compatible with an export to Excel ie. would look the same. Thanks in advance, Graham
-
numbering child rows
I have a sheet I've been using for a while. I just added a column and set it up to auto number. All the rows increased sequentially, e.g. 1, 2, 3 etc. The child rows, and their child rows continued in orer, in otherwords the child of parent row #1 was #2. I'd like the child of Row #1, to be 1.1 or something like that. Be…
-
Dynamic Hierarchy
I am in the process of developing some work flow sheets for my team and I would like them to do the bulk of their submissions via web forms. Is there a way to create dynamic hierarchy whereby when a form is submitted, x criteria places that new submission under the correct "Parent"? Let's say that I have 3 Categories…
-
Start / finish Dates
I need to show the proposed start/end dates in the program to my client. He also wants to see actual start/finish dates. Is it possible to do this?
-
Nested If using Date
Hi all, I have looked through the discussions and cannot find the answer, if it is a previously answered question, my apologies. I have three columns relevant to the question: Due Date Status Completed Date Status has conditional formatting, red, yellow and green corresponding to Awaiting resolution, overdue and completed,…
-
Conditional format using two columns
Hi, I have two columns Planned start and Actual start. I can't seem to set a conditional formatting rule when Planned start is not equal to Actual start. Please assist. Y
-
Multiply total project cost by percentage to get sale price
Hello! This is my first post, and I know the answer is simple, but here it goes: I want to take a total project cost column and multiply it by a percentage that is inputted into another call, and have the answer populate an "Extended Price" column. Eventually I want to be able to add subtotals and do the same thing, but…
