-
Creating a cell link to a different sheet with different working days
Dear community, I have created a sheet for Data Center migration planning. By definition these activities are planned during normal working days (Mon-Fri) but the migrations happen during weekends, as it requires to stop servers and so that's the lowest impact to services. This sheet has defined all days as working days to…
-
Printed Calendar View of Report
I'm sure this answer is out there and I'm just using the wrong lingo but when I print my report in calendar view, the font is too light on the dates and I can't locate how to make them darker/larger. Is that just me or is that a thing?
-
Task lists /
We are trying to create both task sheets (sheet level filters) and reports (multi sheet filters) We are using not ticked as complete and finish date of less than today. We are selecting the 'today' button for the date, will this change the date daily or do we need to run seperate reports?
-
Show Week Numbers on the Gannt Chart
On the chart you show the months, but it would be good to have a week number listed as well. ideally week from start of year and also the option to have a week number starting at the begining (start date) of the project to see how many elapsed weeks there are.
-
Counting Based on Two Items
I am making a sheet to track the number of proposals we send out and how many turn into projects. I want to be able to count them by which Project Manager did it. So I have a PM field for the Project Managers initials. I was using fields for each PM's Proposals. The formula I used was COUNTIF(PM:PM, "RM") for example and…
-
Report Error
Hello, I am trying to create a report that brings in multiple date types so that I can use the calendar view to see my marketing and PR activity. I created a marketing campaign tracker and PR campaign tracker. The marketing campaign tracker has a launch date and end date and the PR tracker only had one date. I tried to…
-
Past Due Reports
GOAL - Tasks Past Due Report for Multi Sheets I have several sheets with the columns set up as seen below: (Type 1) Rows have Tasks with a Contact under Assigned to, "Required" column has a symbol and % Complete is not required so it's left Blank. (Type 2) Rows have Tasks with a Contact Under Assigned to, "Required" column…
-
Conditional Notification / Alerts
Hi Smartsheet Community, I recently posted a reply on the smartsheet blog (https://www.smartsheet.com/comment/46032#comment-46032) and Diana Ramos kindly replied letting me know that Conditional Notification might soon be available. Diana asked me to add a thread here to capture and direct the programmers to ensure our…
-
Report for when a column has been modified in last X days?
Hi all, starting with a sheet that includes all marketing tactics for all of our projects, I'd like to build a report that rolls up every row that has had column "Designer" modified in the last X days. Is that possible? I can't figure out how to do so. I cannot add any formulas or conditional formatting to the master sheet…
-
Keeping parent Task during filter search
I have been using the Parent Task as a header for child task below. The child task has an owner, the header does not. I'm in construction so for example the Contract header has child items such as site visit, develop scope etc. My owners don't want to see all the items that they don't own and I have a filter for each owner…