-
Time Tracking
I have been tasked with creating a time-tracking sheet to hopefully avoid looking elsewhere. We have various areas that work on the same project, so we need to track their work. I have started by creating a parent row (listing the name of the project) followed by the various columns of data we need to track. However - and…
-
Resource Placeholders?
New (or "re"new) to SmartSheet (not project management) and I am trying to do something that would be easy in MSProject, but for which I am hitting roadblocks accomplishing in SmartSheets. When planning out projects, we would normally use resource placeholders, until actual resources are assigned, i.e. Engineering,…
-
Usability of contact information
Does anyone know a way of using the contact information when a new contact name is up-loaded into the sheets? I specifically refer to the e-mail address, as i'm unable to copy and paste into an e-mail from that tab. To date i have just been using a separate column for e-mail addresses, but this seems to be doubling up on…
-
Multiple Photo Upload For Webform
Is there a way to load multiple photos/files using a webform. It appears that to upload a number of photos at the same time on a webform you have to go through and click on each image - individually.- It would be great & quicker to make multiple selections if possible.
-
Automatic Address Finder
Does anyone know if smartsheet has a feature whereby the address can be located automatically by filling in the postcode on a UK Address similar to https://www.parcelforce.com/postcode-finder It would be great if someone knows an app that can be integrated into the platform/worksheet to allow for me to select the correct…
-
Storing Video as an Attachment
Is it possible to store a video as an attachment on Smartsheet? I'm trying to create a method to train our field service personel and would to know if there is the ability to download a video to their phones/tablets - or to upload a video frmo their phones to a smarsheet line. Would appreciate any advice. Thanks Brian
-
Notifications
Hi Guys, Im trying to set auto Notfication I have a Project sheet with Date type of coulmn called "Last Updated" I have another text Column Called balance Due I want to Create a notification if Balance due is higher then 0.00 Send Reminder 2 days after the date in the last updated Column and if not do able with smartsheets…
-
Weighted Percentage for Parent Rows
Instead of an even roll-up - can the parent percentage be set to a specific value relative to the project - see my example below; 1. (Project) Big Steel Project - 100% 2. (Parant)Steel Box - 50% 3. (Child) Bottom 70% 4. (Child) Sides 30% 5. (Parant)Steel Post - 30% 6. (Child)Short Posts 20% 7. (Child)Long Posts 80% 8.…
-
Update Requests (Templates - multiple cc's?)
I have a standard request that gets sent to different people to update a row or rows. There may be more than one person responsible for the updating. I tried sending the request to 3 people but only the first gets the "open form" button. Also, I want to CC their supervisors instead of just me. Is there a way to create a…
-
Cell Change Counting
Hello, Is there a formula that will count the number of times a cell changes? Thanks, Rozan
