-
Duplicate folumla
Hi, I am creating a formula to identify duplicate 'Date of Visits' by 'Clinician Employee ID.' While I have successfully created this formula using a single column lookup value, I am encountering difficulties when trying to apply it to multiple lookup columns. Example below: I am looking for a 2 in the Duplicate Schedule…
-
Help with Join+Collect Formula
I need to reference another sheet to join and collect the skills of employees. The yellow is my desired outcome, and I'm using the following formula. Formula: =JOIN(COLLECT({Detailed Resource Data Master Range Skills}, {Detailed Resource Data Master Range Emp ID}, [Employee ID@row), ",") I'm not getting any errors, the…
-
INDEX, DISTINCT, and MATCH formulas
I am trying to put together a list of our project managers and which business units each of them are responsible for. I need it to be in a certain format because right next to each of the business units, I am going to have 3 COUNTIFS formulas to count different things based on the project manager and business unit. I…
-
Override Column Formula
Hi, I have a column that uses a column formula to automatically calculate a date based on other columns' criteria. However, we sometimes need to manually adjust the date and override the column formula. Is there a way to do this? Thanks!
-
Help with referencing data that is input through a form
Hi all, I'm hoping someone can help me with my specific issue that I cannot seem to resolve. In our Workspace that is set up through control centre, we have a sheet called a Checklist that is populated for each of our provisioned projects. The information in the sheet is populated via a form, as there is around 50 columns…
-
Removing Decimals from Duration Average Calculation
I have a report of every project timeline in my portfolio and an average duration calculation grouped by project phase. I would like to have the averages be displayed as whole numbers but there is no way to remove the decimal place on the report. The parent sheets don't have decimals so I'm not sure why they would appear…
-
Convert a Sum into Currency format $#,##.00
I have a formula that creates a note and within that note is a sum of numbers. For example, JOIN("This is your total: $" + round(sum([Number1]@row, [Number2]@row), 2)) When I use this formula, the results look like "This is your total: $34000.00" when I need it to return "This is your total: $34,000.00". When I use…
-
Can Someone Share a Working WBS Formula?
I'm having issues with WBS formlas. I have 3 columns: RowID Level, and WBS I pulled formulas from a Smartsheet template online (from a forum) but it's not working properly. The first row is the Project Title The second row starts Phase 0 - Project Initiation — it starts with 1, Numbering structure is 1, 1.1, 1.2, etc.…
-
Concatenating Contacts List Columns but Omitting One Option
I have two contact list columns that I need to combine into one column. One of the columns however has "Not Applicable" as an option. How do I concatenate both columns but not include any instances of "Not Applicable". Contact Columns are Program Lead and Internal Speaker (this is the column which contains "Not Applicable"…
-
Rolling Calendar Visual
After a few different approaches, I was able to put together a set of metrics using various formulas and corresponding visual for a rolling 12 month calendar based on the underlying data set. The data set spans across multiple years and I wanted to create a rolling calendar that always displayed the most recent 12 months,…