-
Automatic Timeline Changes
Hello! Newbie here to Smartsheet. I am working on a project that requires a timeline of multiple items with deadlines that are dependent one each other (i.e. can't start phase 2 without completing phase 1). What formatting can I use to automatically push back phase 2 and 3 if phase 1 end date or start date changes?
-
Using iframe the header row of the GANT chart is not legible
Any ideas to solve the following issue? I created an iframe inside an internal collaboration tool (IBM Connections). The iframe works OK apart from the header row of the gant chart. In a browser window I see The text is there - but it is white on white.
-
combined form
Hello,Is there a way to collect data automatically from google docs (word document not a form) to a spreadsheet? I have a questionnaire that each student need to fill in personally and I need that the personal data like name, age, phone No', will be collected automatically into a spreadsheet. thank you
-
ISBLANK question
Greetings, For the life of me I can't get this to work: This is the formula I have for the far right cells, I took out my test for ISBLANK, I can't get it to work: =IF(6500000 - [Total Earned]10 < 0, (6500000 - [Total Earned]10) * -1, (6500000 - [Total Earned]10) * -1) Can I get a hand with this? Thank you David
-
Set a task that has a set (firm) date and predesessors
Hi, Is it possible to set a task with a "must occurr on date" with a duration and Predesessor? Exmple of use: I have some tasks that people need to complete before I send them on an external training course. The course has a set date and cannot be changed. Therefore I do not want the course date to change in the task list…
-
Google form → SmartSheet → E-mail Alert
I created a google form that is linked to a smartsheet. (I had to create a google form because smartsheet doesn't have a multicheck option available for the web form capability). I'd like to use the alerts capabilities of SmartSheet so when someone fills out the google form, the answers to go the smartsheet, and it will…
-
Easier way to populate discussions?
One of the ways we use SmartSheet is to help us manage parts that experiencing a supply/demand imbalance. Because SS doesn't have dynamic updating (i.e. vlookup), we had to structure the tables with a static snapshot on why the part made the list. For example, number of past due orders, inventory levels, etc. Once a part…
-
Modify an existing report sent via Email with Attachment
One of the databases we built using Smartsheet allows us to facilitate communicating with various people from different functions. That means we have to create different reports that filter some of the data. We use the "Email Send as Attachment" feature to set up recurring emails that are sent to specific people at…
-
Help Smartsheet Improve our Help Center
Hi, I'm a user researcher with Smartsheet. My team and I are working on some improvements to the help center. We are looking for your help no matter what your experience level is with Smartsheet or the Help Center. If you have not already participated in this interactive survey, please help us by doing so. It should only…
-
Tracking actual dates without losing predecessors ?
i use baseline start/finish columns and scheduled start/finish columns. The start column uses predecessors but I also update the start/finish columns for actual start/finish. The downside to updating them is that i lose my predecessors (they are deleted when I manually change start/finish). Is there a SmartSheet best…
