-
Can I populate a multi select contact list off of what is selected in a multi select drop down?
I would like to populate a multi select contact list in the Master Sheet below based on what is selected in a multi select drop down (Project Requirements). The Lookup Sheet on the right lists what should be populated based on what is selected. It's only reading ONE project requirement. Any assistance would be greatly…
-
Identifying Duplicates
I am working on a sheet that contains IP addresses. When reports are added to this sheet, I am currently going through the data and marking any duplicates. I want to find a way to either use conditional formatting to highlight the duplicates or any method that is available. Is this a possibility without inputting the value…
-
Formula for RYGB Status
Hi, I'm currently using this formula for status health but it's not the best because "Not Started" status is not showing Red if the End Date for the task is in the past. Obviously, the task is overdue even if it hasn't started. Can anyone assist to make this formula better? =IF(Status@row = "Complete", "Blue",…
-
RYGB health changes on date and status
=IF(ISBLANK([End Date]@row), "", IF(Status@row = "Complete", "Blue", IF(NETWORKDAYS(TODAY(), [End Date]@row) < 0, "Red", IF(NETWORKDAYS(TODAY(), [Start Date]@row) <= 6, IF(Status@row = "Not Started", "Yellow", "Green"))))) Goal: Health RYGB balls. -red, end date past due in any status -yellow, start date <=6days of today,…
-
Insert approvers name and date/ time of approval
Hi all, I have created a form and a workflow for approval. In short: Somone submits a form Details email to an approver Approver either approves or declines (would also be good to have more than 2 options i.e. defer) The smartsheet updates to say approved or declined What i cannot figure out how to do is show who approved…
-
Unable to create cross-sheet references
The system shows a message "Unable to create cross-sheet references because this sheet already contains the maximum number of different cross sheet references" . How many references we can do? I am using a sheet that has information of 13 sheets combine. (like a summary sheet). I like the summary sheet but the information…
-
Multiple Updates to a Single Row
Hello, I am trying to create a "tracker" that show the progress of a shipment that contains multiple steps that are updated as each step is complete. So essentially the Tracker sheet would pull all the new entry submissions and update submissions from the dump sheet, to one row on the Tracker for each shipment. There are…
-
Help with Formular with two criteria adding to date value
Hello, I am assisting a team in moving from an excel sheet to Smartsheet. The formula they currently use to perform a calculated function isn't working and I am getting INVALID DATA TYPE as the error. I admit I am not the best formula writer. Basically if the new row meets he two criteria only then should the cell populate…
-
Sumifs with AND and OR Criteria
Hi, I'm trying to collect a "Total Amount" if the following criteria is met: The "Category" is "Banking" The "Owner" is "Resident" The "Account Type" is "Checking" or "Savings" I figured out how to do Criteria 1 and 2. It's Criteria 3 that is getting me stuck. I know I can combine a few different Sumifs formulas together,…
-
IF(ISBLANK formula for multiple columns
Hi I want a formula to show which team has been selected across multiple columns: So if Construction has been chosen, in one of the columns, this will show in the Team column. Only one team will ever be selected per row. The formula I have is shown above but it's returning a #impasserable I'm assuming I've got too many…