-
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!
-
How to project a completion date with predecessors and durations
I am building out Engineering project plans. I'd like to be able to pre-plan the work out by using predecessors and approximate durations. However, if the first line item in the plan does not yet have an end date the predecessors/duration will not calculate to give a projected end date for the project. I had a call with…
-
Generate documents are generating "0" randomly in the fields
Hi everyone, testing this new Generate Documents function. In my PDFs there are randomly generated "0" in between numbers. Note these "0" appear ONLY where numbers are inserted into fillable fields. Where there's only text inserted - no zeros. What i've tried so far - try setting field as "number only", tried formatting…
