Manipulating Smartsheet
Hi Group
New to using Smartsheet
I have the following questions
Question 1
When creating schedules, is it possible to have Smartsheet give days or weeks from planned start date?
Example:
Start date: October 11
Planned Week Duration: 2 Weeks
Resulting Date: October 25th
Question 2
Some type of revision control
Trying to distinguish a Work In Progress schedule vs. a Released schedule
Question 3
Printing - How or where to insert company logo
Also when printing, it's not showing all columns and/or Gantt chart
-- How or where to fix this?
-- Also, how to remove the Smartsheet logo
Answers
-
Question 1:
Create 3 columns -- Start Date, Duration, End Date (make the Start and End Dates be Date Columns)
Have users input their Start Date and Duration (in weeks) in manually, then put this formula into the End Date column:
=([Start Date]@row + (7*[Duration]@row))
Question 2:
Create a dropdown column with the two values you'd like to filter between and create a filter for each one.
Question 3:
Go to Personal Settings, Personal Colors & Logo..., then upload your company logo that way.
You can also select a custom date range for the Gantt chart as well as a custom page size if you'd like to change the proportions of the page.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives