-
Using a formula =CONTACT wont populate actual contact info subtasks
Help! At the top of my projects, I am including the resources involved. I'd like for subtasks to be auto-populated when I fill in a resource. Example: in my resources section, I set the HL7 Engineer to Joe Downing. I have it set so all HL7 tasks then populate with Joe Downing. PROBLEM: Joe Downing's contact info doesn't…
-
Duration Summary Calculation
I have project that requires hour granularity for assigned tasks. When Smartsheet summaries each of my branches for a day, the sum is always .25d for a day that has 8h (sometime more or less than 8 for a working day). I have had to augment the inaccuracy of the duration summary with another column in the Smartsheet to get…
-
The predecessor changes the start and finish dates
Hello, I'm creating a construction schedule. I entered all my start and end dates which automatically calculated the duration. The problem is, when I enter a predecessor, it automatically changes the start and finish dates; why is this happening and what can I do to stop it? Thank you.
-
Dynamically update dashboard after form submission
I am experimenting with the Sights feature, and attempting to have my dashboard update whenever a new web form is submitted. We have some metrics that are manually updated every week, and I'm hoping to auto-populate an overall view. However, a new form submission doesn't update any of the numbers in my Sight, they are…
-
Search: No ability to search in attached PDFs?
Hi, I've read through the documentation and know that at this time there's no capability to search inside of PDFs...however, I noticed search enhancements on the roadmap and wondered if searchable PDFs were part of those enhancements? Would love to know. Thanks!
-
Setting Alerts for new Webform submissions
We are using webforms to gather feedback after a system upgrade. Is there a way to set an alert to send an email when a new item is added through a webform?
-
Need help making a COUNTIFS NOT formula
Hi there - I want to count how many times column A shows Katie and Column B does NOT show "Completed" looking at a range of rows - I have no idea how to make that happen :( I can do the COUNTIFS over and over again for all the different things that column be could be that aren't "Completed" but it seems there should be an…
-
Conditional Notification / Alerts
Hi Smartsheet Community, I recently posted a reply on the smartsheet blog (https://www.smartsheet.com/comment/46032#comment-46032) and Diana Ramos kindly replied letting me know that Conditional Notification might soon be available. Diana asked me to add a thread here to capture and direct the programmers to ensure our…
-
returning a blanc and auto created dates
helpful friends, Please see screenshot. I have a formula in B that returns a 'o' when other cells are unpopulated and I wish to show a 'blank' can this be done? Also because I have createsd a formula that I have copied down the length of 'B', the 'Created' Column 'A' is auto populating with the date that I populated the…
-
Result look up
Hi, I am a beginer at using Smartsheet however have been successful to date in creating a workable module for my sales team, however, within one of my module sheets I have a list sales attributed to sales staff which uses a Decision drop down list "yes" symbol indicating a sale has been completed. My question is, how can I…