-
Using "Flag" in and IF function
Hello! I am looking to create a formula for the RYG column that would work like this: If Status column is "Overdue", then it shows "Yellow" If Status column is "Complete", then it shows "Green" If Status column is "In Progress", then it shows "Green" If Status column is "Not Started", then it shows "Grey" If At Risk column…
-
Critical path in a report
Hello there, I am looking for a way to show my critical path on my dashboard. I assume I need to create a report of critical path. the question is; how can I filter my critical path in a report. My aim is to have this automatically show it, updated, every time I open my dashboard. Is there any attribute related critical…
-
Sheet folder Template
1.We have 5 sheets which are interconnected through formulas the whole folder or workspace needs to be saved as new template Note: The formulas should not be removed Is there any way for this? How to create a template set?? Thanks, Keerthana
-
Formula question - count projects by status, category and date
Hi Everyone, I want to count the number of Project IDs where the Project Status = "Complete", the Project Category matches the column header (AV-TV, Software, etc.) and the End Date is greater than 2022,09,30. I can count the number of overall complete projects for the project category without the date, but cannot seem to…
-
Average for Filtered Children Rows Only
Hi! I have sheet with a column Y or N that I filter on. I filter on all the Y and am trying to get the average for the children rows (they are a %). However, it's averaging all the children rows (not taking the filter into consideration). How can I get the average for ONLY the Y children rows? Thanks!
-
Linking Sheets - Asset Management
Good morning, Hoping someone can help me out. I have searched the community boards and cannot seem to find an answer! I currently have a form that users submit to request a repair on a piece of equipment. The requests then go to the Cold Equipment sheet or Hot Equipment sheet based on equipment type (refrigerator, steamer,…
-
Index to equal exact matches
I created a formula that should look for a specific cell within a range from another sheet, and report back another column. However, it does not search an exact match. Formula: =INDEX({Res Sales Metrics Month}, MATCH([Date2]@row, {Res Sales Metrics Year-Month}), 0) I want my month name column to report back the actual…
-
If Then Statement on Column Cells
None of my usual Excel tricks are working for an "IF Then" Statement on my new Smartsheet Spreadsheet. I am trying to set up a formula so that if cell #18 on Column 8 is "N/A" then "N/A" is returned in cell # 21 but if any other value is in cell #18, nothing is returned to cell #21 as I will need to manually add a value to…
-
Nested IF/INDEX/MATCH Challenge
I am stumped and hoping someone can help. Here is my sheet: In the [Partner Name] column, I have this formula: =IF(OR(BEGEOID@row >= 34, BEGEOID@row <= 94956), INDEX({BEGEOID Partner List A Partner Name}, MATCH(BEGEOID@row, {BEGEOID Partner List A BEGEOID}, 0)), IF(OR(BEGEOID@row >= 94957, BEGEOID@row <= 431490),…
-
How do i create a status column based off of levels and approvals?
I have to create a status column that uses 3 different levels that each require different people to approve. how do i make one big formula for it all. For example level three needs person one to approve, then person two, then person three. then the status can be complete. basically i need if status is level 2 then person…
