-
Risk Rating Formula
Hi all - I am trying to create a long formula and need some assistance. For a Risk tracker I have 2 columns (Probability and Impact) both which have list values of High, Medium, Low. Based on those selections I want to have a 3rd column which is the output of the formula, Rating, designated High, Medium, Low. Below are the…
-
Required advice on creating a view on Overdue tasks
Hi, Smartsheet champions. Does anybody have ideas on creating a view like below (or similar) on Overdue tasks? Perhaps creating a column in tasks sheet with formulas to calculate the Days Ago number and pulling a report will work?
-
IF Function / Formula Help
I have created a budget sheet template and need to add seasonlisation to identify cross-charges by month. Rather than doing this manually every time, I would like to add a formula that pulls the data from another cell, but based on information in a 3rd cell. I was hoping it would be as simplistic as: =IF([Activity Month]3)…
-
I am needing help linking cells to another sheet based on specific criteria.
I am trying to link cells to another sheet (Name column) based on the specific local chosen that they are in (Local #26). I have tried using this formula below, but it only populates one name not the entire set of guys in that union. =INDEX({Safety Awards 2024 Range 1}, MATCH("Local #26", {Safety Awards 2024 Range 2}, 0))
-
How to add time or subtract time from a date when "check" is selected?
Hi! Looking to see if this is possible. I have a packaging release date column that current pulls from another sheet for all items. I have items for Disney that I need to subtract 30 days when I click Disney checkbox column. When I uncheck the checkbox column, I want the date to revert back or add 30 days back. Here is the…
-
Review a Formula
I am trying to sum all noted columns and getting UNPARSEABLE. Help! =SUM([A. Need for the Project/ Project Narrative]@row, [A. IPVE Need for the Project/ Project Narrative:]@row, [BONUS]@row, [B. Demonstration of Experience and Proposed Servic]@row, [B. IPVE Demonstration of Experience and Proposed]@row, [C. Demonstration…
-
Formula Issue
I want to get a dollar amount based on if a checkbox is selected. I am running a program where participants can get gift cards as incentives. I am using a separate sheet for the amount for each incentive. The other sheet columns are named the same as the incentive. Each column is a checkbox. To explain what I want, let me…
-
Add Or Condition to my formula
Hi. How do I adjust my column formula to include Status <> Complete or <> Phase 2? My formula is: =IF(AND(Finish@row < TODAY(), Status@row <> "Complete", Health@row <> ""), "Yes", "")
-
Nested IF / AND Statements
I'm trying to put together formulas that will allow me to report forecasted labor across the months a project is active. I have all the formulas working individually but can't figure out how to group them into a singular formula. For example: Project Start: 6/17/24 Project End: 8/21/24 Forecast Cost: $10,000 The way I…
-
How can I exclude "child rows" when executing VLOOKUP?
I am currently trying to update the VLOOKUP formula to exclude child rows. I setup a reference sheet to run the formula, but the only way for it to run properly is to add the child rows. If any child row value is changed, it shows as #NO MATCH, however, I would just like to appear blank. I am currently running the current…