-
Embedded IF(AND(OR Function Help
Hello, I have three columns in my sheet each with dropdowns including a "Complete" - type answer and a "Not Required". In the fourth column, I am trying to write a formula to show when the row is 'good to go' - such that all three columns read either "Complete" or "Not required". I've tried to do this by embedding an "OR"…
-
Count If Assigned to... and status not Complete (two columns criteria)
Hi All, I have a column called 'Assigned To' - this contains smart sheet contacts from a drop-down. (can be multiple people) per task. The second column is called 'Status' - It has a limited range of selections. Open, Complete etc (can only be one selection) I am trying to create a formula that will solve this text…
-
Project Plan - Manually Changing "Start Date"
Hi Team, Can anyone help me why I am not able to manually change the start date .. I want this functionality to be disable so that the user can manual change start date related to task name assigned. Please help
-
Need help in AverageIf formula with 2 condition
Hi team, I need help with an AverageIF formula. I am working on the request tracking system for Import shipment. I would like to calculate the average days in transit with 2 conditions, 1. Country (USA, UK, Sweden, etc), 2. Mode of transit (Air mode, Ocean Mode, Courier mode) + Average days in transit. Existing AverageIF…
-
SumIF HAS with cell linking
Hi All, I have been struggling to find a solution on how to get a Sumif formula to work. Essentially, I want to Sum if a cell contains a specific name, however the name column is multiselect and can have multiple people in it. I have tried both the HAS and CONTAINS formulas but haven't been able to get one to work. The…
-
CountIF or CountIFS
I was able to use CountIF correctly to capture all the requisitions that had the status "recruiting/sourcing". Now I want to count the number of requisitions that have that same status, but are also in the Job Family (which is another column) "Information Technology" . I tried to do CountIFS and didn't work then I tried…
-
Options for Sheet Totals to Drive Dashboard Chart
Greetings, Community! Looking for some guidance relating to sheet totals and how to plot them on a chart. The below screenshot if from a pivot sheet. I mocked up a set of totals rows at the bottom of the sheet. My goal is to SUMIF based on the Category (SM, PF, PL, SysOps) for each time range. I'm looking for a solution…
-
Smartsheet Formulas for Risk Assessment
Hi All, Has anyone used Smartsheet to monitor risk? I am curious how this was designed and how effective it was. I am looking for something that could populate a dashboard. Could I populate a simple dashboard showing some levels of risk in areas that looks something like this? A. INHERENT RISK SCORE: Risk Impact: Value…
-
Common List
Smartsheet newbee here...so bear with me... I'm tying to create a common list of systems of which there a multiple scopes of work associated with a each system but not really related ot each other....therefore, I would like one sheet which simply lists all the systems, along with basic information....then another sheet…
-
Health formula error
I'm learning how to set up the Health column. I have followed the various conversations and got to a point where most of the formula is working. I am stuck on an issue and would like help. In the Status column we have the below series: "Complete" or "In Progress" = "Green" | "On Hold" or "Forecast" = "Blue" | "Schedule" or…
