-
Formula Error
Hi I have the following formula that should look at the number of projects in a programme RAG statuses and return back a Red if there is 1 or more project with a Red RAG, return a yellow if there is 1 or more projects with a yellow RAG, otherwise return "Green". =IF(COUNTIFS({Project to Programme Summary | Project Status},…
-
Delete or Modify Cross Sheet References in Smartsheet Gov
Smartsheet Gov doesn't offer the same handy-dandy Sheet Reference Manager as the commercial version (don't know why) that allows you to delete, etc. Is there a good, easy way to do this in Smartsheet Gov?
-
Someone please help me get the "=COUNT(DISTINCT(COLLECT(" formula correctly?!
HI there team, Trying sum up the Summary screenshot by unique Shops/Customer registered. Data is coming from the different file which is a registration file, and for some reason I cannot get the formula to work. Attaching a sample. thank you!
-
Auto fill column with value from first cell in another column
I have an application where I use a header row to collect higher level project information, like overall project status, project start and end dates (as opposed to task start and end dates), etc. I copy rows from individual project plans to an "all projects" sheet from which we do some PowerBI reporting. I need a column…
-
Reference cell in column on one sheet, against column on another.
I am trying to create a formula thagt will look at the "Item Name" columns numbers, and then check to see if any instance of that number appears in a column on another sheet, and if it does return "True", and if it doesnt return "False" I've had a similar equation in excel "=NOT(ISERROR(MATCH(A2615,'Up-To-DateLK'!A:A,0)))"…
-
INDEX (Match) Formula with contact columns
Hello, I am using an INDEX(MATCH) formula referencing 2 contact columns and it works great. However, when I try to convert to Column Fx it will not let me. Can we not change contact columns into formula columns? Or is the fact I am referencing contact columns in my formula a problem? I am not referencing partial ranges.…
-
Show tasks completed in calendar week?
Is there a way to count the number of tasks completed in a calendar week, Sunday-Saturday? I have a metric that shows the number of items completed in the last 7 days (>TODAY(-7)) and I've been asked if the metric can show items completed in the calendar last week, meaning Sunday to Saturday, rather than a rolling last 7…
-
IF Formula with Multiple Criteria
Hi all, Working on an IF formula with 3 conditions. IF Value = 0, "No probability of Risk: Functionality requires evaluation and/or validation when/ if the functionality is intended for production use." IF Value, 2-36, "Low probability of Risk: No Computer Validation testing required." IF Value, =>36, "Medium probability…
-
How to write a formula with multiple conditions?
Hi, I have these 5 Phase columns in my project tracking sheet. Now i want to automate the column named "Test" that shows at what phase the project is currently in. The logic is something like: "If the Phase 1 is 100%, Phase 2 is 45%, Phase 3 is 65% then the project should be at Phase 2" Ideally if the phase is at 100%, It…
-
How to apply a priority countif formula to specific rows based on cell criteria?
Hello, I am using the following formula in a priority column to maintain ranking number when filtering my sheet. I would like to apply this formula to the rows based on criteria in my "Open, Backlog, Closed" column. For instance, if a closed is selected for a row, i do not want the formula to apply to that row.…