-
String Formula/Substitute Formula
Hello, I have two questions. Can someone help me understand the coding created at the end of this string query I use for a prepopulated form? Also, when I add a new section looking for the "Time," do I need to add an extra substitute in the formula, and do I add any "codes" at the end? Here's the formula I'm referring to:…
-
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…
