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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives