-
Different columns with the same name ?
How can i make several columns with one same name???
-
FORMULA - Estimated vs Actual Time
FORMULA HELP NEEDED (See Screenshot) I need help creating a formula to show: IF "Actual Time" Column is 10% more than "Estimated Time" Column, then "ERP vs ACTUAL" Column shows "DOWN" Symbol IF Not, shows "UP" Symbol. Times are entered in minutes (00.00) Thanks in advance! This is what I currently have: =IF(AND([Actual…
-
Comparing Actual Duration to a Projected Duration with a +/- days
Three columns used are Duration(dependent), Projected Duration(I initially copy all of the durations over when setting the project) and +/- days(calculates the difference between Duration and Projected Duration) The trick here is you need to strip the "d" from the value to allow computations. =(VALUE(LEFT([Projected…
-
New notification feature doesn't send an email to all the users specified
I set up a new customized notification yesterday and set up the email delivery for myself and 3 other colleagues. However, I was the only person to receive the notification email this morning. Did I do something wrong or is this a programming issue? I have included a screen capture of the notification set up. Thanks.
-
max Rows that can be sent.
I have a bit of an issue . I have filtered a section of my sheet it has 75 row . I select it and click send . the customer however recieved 50 . Is there a limit to the send functionality . could use some help
-
Hidden sheets in a Resource View
Hi I have a Resource View and some resources are shown 150%, as they are mentioned in a long-forgotten sheet (displayed here as "Other sheet") that is not maintained anymore, not shared and the owner is unknown. How can I figure out where this particular resource is used please? Thanks Attila
-
"Modified / Modified by" fields
I noticed that when I save a shared sheet, the columns "modified" and "modified by" change to my login and the time stamp when I saved for ALL rown in the sheet. Is it how those column types are supposed to work? In the help contents, I read that those columns change ONLY in the ROW where data has been changed. It doesn't…
-
Formatting for Project Lists - suggestion
I was hoping there was some formatting option so that when I set a status to complete (either green orb, full circle etc.) that there would be a way for that row to automatically be moved to the top of the sheet. That way the "in progress" and "completed" tasks/projects could be better organized. Just an idea. Thanks
-
Report planned work on a weekly basis
Is there a way to know the estimated % of work to be done every week? I didn't find a report about this, but this will be very helpful to track the overall execution of a project. Example: week 1=5%; week 2=18%; week 3=24%; week 4=32%; etc...
-
Card View
Any Card View Users? See Screen Shot How can I get Card View to specify the Column Name on the card? Ex: On the Left Card - "JOB# 10002121" 10002121 is JOB# Column but when I'm looking at Card View it doesnt clarify that. I can work around this by manually adding "JOB#" in the cell before the #s HOWEVER, when it comes to…