-
Linking within Sheet
I know you can use = to link cells within a sheet, but if I needed to link an entire row, is there a way to do that? Or even a couple cells at a time? I tried highlighting all of the cells I need to link & doing a bulk edit sort of thing, but that didn't work. Wanted to ask before I spent an hour linking a million cells…
-
creating formula to add many non-adjacent cells
I need to sum/add many (~120) non adjacent cells. They are all in a single column. When I create a formula and start clicking in the cells to include, I keep being returned to the bottom of the sheet where the formula is calculated. Then I have to scroll back up to the top of the sheet to access the next cell I want to…
-
Recuring events
Hi there, Is there a way to schedule recuring events in the timeline without having to insert new individual tasks? This would be for recuring site meetings etc. Thanks Annina
-
Is there a way to select from a project schedule the next upcoming milestone?
Is there a way to select from a project schedule the next upcoming milestone. I have a flag column identifyng milestones and a column that calculates for just milestones the number of days between the task finish date and today's date and therfore the lowest value is the next upcoming milesone. I desire to pull the…
-
Resource View: % allocated bar
Hey team. When I look at my resource view, both within the project, as well as in the Resource View area, the colored bar is not over Mon-Fri, but over Tues-Sat. I have already changed my account settings to show that our work days are M-F. Ideas?
-
Assigning contact to multiple tasks
Is it possible to assign a contact to more than one task at the same time? I have a sheet with 65 rows - there are contacts with multple tasks so trying to avoid having to pick from the list on each single task. Thanks in advance for any help offered.
-
Multiple Projects in IT, each may impact the other. Is there a smartsheet for this?
We are a firm working on one project in IT. We understand, after interviewing people in many different departments that other projects will impact our project. How can we manage this using smartsheet? Is there a template available for impact/conflict? Thanks in advance!
-
Print with Sheet Name on All Pages
The sheet name only prints on the very first page, and I have to write my sheet names on the top of the other pages all the time. Since there's an option to print with the page numbers & time stamp, it'd be great if there were an option to have the sheet name on every page, insead of just the first one. Thanks!
-
How can I get Calendar view info to wrap so it can display more than 20 characters?
I want to be able to show more than the 20-25 characters limited in the display of a calendar entry. e.g., I need to be able to show an "Issue No. (10 characters) + an Impact" which can be a list of multiple things. I would not mind if it wraps around into a second row as long as it displays all the information needed by…
-
Continuously moving inventory - keeping a record without overwriting current information
Hi there, We have an existing Inventory database in Excel that i have imported successfully. However now I need to figure out - if I can - how to 'track' the movements of any given piece of equipment. For example we have a Computer Monitors that are 'loaned' to customers every so often. I woud like to keep a 'log' of the…
