-
How to form a =COUNTIF Column in reference to an already formulated 'Unique Column'
To further explain in reference to this community post. here, https://community.smartsheet.com/discussion/57396/generate-list-of-unique-values-index-distinct-vlookup/p1 I've successfully been able to apply the formulas suggested from that post and build out a column of unique names. Now in a separate column I'd like to be…
-
% Allocation Formula for Assigned To column
Hi @Genevieve P. Can you please help me come up with an IF formula to use in the % Allocation column for my sheet? This is what I am trying to formulate: If Bob (from the ‘Assigned To’ column) reaches greater than 100% allocation (from the sum of multiple rows), make the ‘Assigned To’ cell Fill in Red for wherever Bob’s…
-
Adding detailed information to a row / task
I have a column set up as "Notes" that I'm using to record all the details of that task. Eg., I'm running a software project so I need more info - it's a new feature, what are the features, what did the customer request, how do we intend to implement it? I.e., detailed info rather than simple notes etc. I can go to Card…
-
Using Countif in place of Autonumber - formatting question!
I'm creating a ticketing system with multiple prefixes. Because of the multiple prefixes on one sheet, II opted to create a nested formula to number the tickets based on the various types of requests. Here is the formula: =VLOOKUP([Request Type]@row, {Ticket Assignment}, 2, false) + (COUNTIFS([Request Type]$1:[Request…
-
Formula to automatically link Week to Date
Hello, we have individual production schedule sheets where we assign hours against weeks. We want to create a column that will autofill with the Date it is starting based on the first Week Number column that has hours in it (example attached). We have this working with a long formula: =IF([wk 23]@row <> "", "06/06/22",…
-
Including Half Day Holiday to Timeline Nonworking Day
Is there a way to add half days as a holiday in a timeline (nonworking days)? EX: We are having a half day on Friday and Monday off for Memorial Day. I was hoping to find a way to include in this in the timeline (nonworking days)?…
-
How to populate a column in a sheet based on a column from another?
Beginner here. I want to populate a column with the names of people in a new sheet, with the data to be taken from a column in an existing sheet. In this sheet, the names are given in the column multiple times over since it reflects each of the accounts these people have. I'd like each individual name to only be included…
-
Looking for most recent date
I have two sheets. The first is a tracker for up coming reoccurring tasks and the second is a copy of rows that have been completed. In the first sheet I would like to collect the date from the "date" column in the second sheet if the "Combined" column values match that on the first sheet and if "Most Recent" is checked in…
-
Control Center optional template issue
Hi All, We are using Control Center for our projects, we use it with 4 different countries and every country has it own set of templates that they can select when creating a project. So in total we have 16 optional templates that are unrequired and unselected. The country then selects their own 4 templates. And creates the…
