-
HELP - FORMULA - equal to AND IF/THEN
Final Decision (WEBFORM) is a hidden column with the webform results in Yes, No, Hold symbols I need a combination formula for "Final Decision" column: 1. To equal the results in "Final Decision WEBFORM" column 2. AND IF "Final Approval" Column is checked, then show "Yes"
-
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…