Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Individual Task List Report (aka "Look Ahead" Report)
We have about 12 projects underway that are using Smartsheet. I'm planning to send each resource on the projects a "look ahead" report that shows all the tasks they are responsible to complete over the next 2 weeks. I've created the report. consolidating the sheets, but have two questions: 1) It looks like I need to create…
Multiple IF formula
Hi I am unable to figure this out. I need a formula that says: If any of the cells Barcode:Barcode contain the term "1 In Production", then add the text "In Production" to corresponding [In Production]1" cell.
smartsheet security certificate not recognized.
I keep getting this message, where chrome reminds me the certificate is not valid. How can I get my Mac/Chrome to recognize smartsheet? I have similar problems now with other items too - apple store, twitter...stuff I use rarely and don't care about, but I need to figure this out to use smartsheet. Thanks for the help!…
Printing
I'm trying to print the schedule without the gant chart. Just the items and date of start and finished.
Need the ability to filter reports based on project status
Here is what I need. I have about 50 projects within a workgroup that I am trying to manage. I have a report of tasks that are due within the next 5 days. Took some cluncky work to differentiate tasks vs summary tasks, but it was easy enough to do. Next issue / challenge. When a project stalls for some reason or another, I…
Macro like functionality
Is there any method planned that would enable a change to trigger other changes. For example, I'd like to be able to cut out a step in one of my sheets whereby if I mark a task as complete that it would automatically change the % complete column to 100 (and vice versa).
How to reference 100's of items with corresponding triggers to designate an end date.
Hi - Our agency has a formal record retention policy that lists over 100 types of records that we store or have digitized in-house. Question to answer/example: If the documents for Site A fall under Record category 1, they should be destroyed on 1/1/11, which is 100 days following the trigger date. I was able to create the…
Dependency between multiple RYGG cells
Hi, Is it possible to create a complex dependency such that a task's status is derived from it's sub-tasks' status. i.e: Status Task AVG(ST1-4) ST1 R ST2 G ST3 G ST4 Y That way we could avoid manually updating task's status manually and also connect it between sheets. Thanks
Changing to Office 365 login
Good morning, We now have Office 365 for some of our licensees/users. How can I integrate my current Smartsheet account under my old email address with our new O365 email? FYI that I do have the Smartsheet app for O365 Outlook installed and am already using it. Blessings, Loann
Reports not updating
I have a main sheet with many reports pulling from it. All was fine until about an hour ago. No matter what I do I can not get the reports to update. All the criteria is correct. Help....
