-
DEPENDENCIES FORMULA IN TO A PROJET SHEET
HELLO; I HOPE YOU CAN HELP ME WITH THIS PROBLEM: I NEED TO SCRATCH A FORMULA TO GENERATE DEPENDENCIES AUTOMATICALLY IN A PROJECT SHEET WITH THOUSANDS OF ROWS. EACH ROW CORRESPONDS TO A TASK REPEATED RANDOMLY. AND MY PROJECT HAS MORE THAN 70 DIFFERENT TASKS, SO IT IS VERY LABORIOUS TO ASSIGN DEPENDENCIES USING FILTERS BY…
-
Price Book Entry Import
Dear colleagues, I am seeking for advice on the following challenge. I am using Smartsheet to update and insert Salesforce Price Book Entries. Inserting a new entry requires Price Book ID and Product ID. If I map these fields, they are imported from SFDC and won't sync to a new entry record. Similarly, if I create new…
-
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