-
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…
-
How do you automate a status updates in smartsheet with IF formula?
My organization would like to automate the statuses in a project plan. Could we create an IF formula to accommodate this logic? Examples: If the start date is in the past and the percentage is 0%, put status in yellow If the percentage is 100%, put the status in green If the end date is past due, put the status in Red
-
Best method to return a list based on a multi-select column
I hope I'm close with this solution, but I just can't make the formula work. I have a list of therapists who are licensed in multiple states. Sheet with formula: A list of patients needing a therapist. Their state is indicated in a "State" field. Second sheet: A two-column range of "Therapist last name", and "States…