-
Multiple Baselines on One Sheet
MY company wants to have multiple projects on one sheet, and they want Bassline's on each project. Is this possible? When I go to the Baselines section on a sheet it only lets me refer to one Target Start and Target Finish. Thanks!
-
Could we make the calculation to a "Report" file?
Hey guys, now I have a question asking for your help: Now there are many project schedule in my workspace, so I use the "report" function to filter some key info and data that I want to summarize and show to the the management team. Could we just make a calculation to a "report" file then create a dashboard from it? Or if…
-
COUNTIF or COUNT - partial strings of Contacts
I have the following formula: =COUNTIFS({SECONDARY - OPCO Log Range 3}, CONTAINS("YKE", @cell)) In the BIC column I have several parties, and the ones associated with my company all have YKE/SJCC-RB, YKE/SJCC-SJ, YKE/SJCC-KT, etc. I want the number of people in my company (my company = YKE/SJCC) that are in BIC column. See…
-
Create a Personal Dashboard of tasks from mulitple Smartsheets
Hi, I'm in the process of thinking about how to create a dynamic Personal Dashboard to show tasks due, what Project it's from, due date, type of task, etc. Here's the background info. We have about a dozen Projects going at once and each has it's own Smartsheet Schedule as well as other associated sheets. This sheet shows…
-
Workspace Sharing Problem
Here's the issue I'm having. I created a workspace. In the workspace I added a Dashboard and several Reports. On the Dashboard I have links to the Reports that are in the shared workspace. So, what I assumed would happen is that anyone on the shared workspace could open the Dashboard and click on the link to any of the…
-
Thousands Separator missing in Report Sum's
Hi all, I went through a similar issue with sum's not showing dollar signs, and managed to track down the underlying sheet culprit that was not formatted correctly. Now I am having issues with the thousands separator comma missing on all sum's. I assume the sum's can show comma's?
-
Daily Automated Workflow when a row is changed - each instance or a final state?
If I choose a daily workflow alert to a person when a row is changed, and the row changes 3 times in the day - all in the same cell (like the date due), will the recipient get each change in the daily email or just the last recorded change?
-
Changing How Control Center Names Sheets, etc, in templates rolled
Good morning - we currently have a template we use to roll jobs. Currently the folders are all named for example: PCO Log, JIS, etc. When we roll the jobs, the project information appears first in the newly created job: Ie 22401- 3rd St JIS. We want to change the order these are created so the folders etc read JIS - 22401…
-
Calculating the next upcoming date in planned events
Hi, I'm trying to calculate the next upcoming date that is after Today. My current equation is: =IF([On/Off Treatment]@row = "Off Treatment", "", MAX(COLLECT([CxD1 Dosing dates (Planned)]23:[CxD1 Dosing dates (Planned)]31, [CxD1 Dosing dates (Planned)]23:[CxD1 Dosing dates (Planned)]31, @cell <= TODAY()))) The date in RED…
-
Auto Numbering Issue
When I go to edit the column properties, it will not let me select auto-number for the system-generated column. Please help!