-
Nested IF Statement Formula
Hello Team, This would be a great formula to incorporate into my daily SmartSheets process within my organization. I would like to know how to create a nested IF statement if this is the correct formula to use, that uses an RYG (red, yellow, green) light flag formula to set the status of a task based on its…
-
How do I populate a Contact List column using VLOOKUP or INDEX/MATCH
Is there a way to populate a Contacts column on a sheet using VLOOKUP or INDEX/MATCH and have the actual contacts from the original sheet populate into the new sheet as opposed to just the names? A bit more detail: The original contact column and the contact column on the new sheet are both Contact List type. Using either…
-
Resource allocation with multiple assigned to
Good day all, I'm working with resource allocation across multiple projects. Resource allocation is turned on for the account and then turn on and off for each sheet I want in the overall program. My understanding is that %allocation is assumed to be at 100% when there's no %allocation column specifying otherwise. In our…
-
Combining 2 Formulas
Hi, I am having trouble combining these 2 formulas: =NETDAYS([Date Sent To Rep]@row, TODAY() - 1) =IFERROR([Over Calc]@row, "") Right now I have 2 separate columns calculating, but would like to have just 1. Is it possible to combine these 2 formulas? I want it to calculate the net days, but if there is not a date inputted…
-
Health Ball Color Based on Dates and % Complete
We are utilizing the RYGB properties for our Health column and trying to improve the tracking of each task using this criteria: * If a task has NOT started and no progress has been made, no color indicator * If a task has started and is not late, but progress has been made, green color indicator * If a task is 100%…
-
If and if/and statement
I'm trying to do an if statement for if a cell is blank to leave it blank and if not to perform an if/and statement. I did it in Excel but when I imported the file into Smartsheet it wasn’t working. So I’m trying to write it in Smartsheet. I did get it to work at one point but the acceptable and review responses were…
-
Formula for summarized health indicators for discrete categories
Hello, Perhaps this has been answered elsewhere - in which case I appreciate being redirected. I am trying to determine if it is possible to create formulae that summarizes a health indicator symbol (Red, Yellow, Green) across multiple rows in a sheet, when further categorized by a variable in another column. So, in other…
-
Formula
HI Team, Do we have substitute to these symbol in Smartsheet or how we can use these function in Smartsheet ">" & i have build this formula in excel and its working fine, but i am getting error in smartsheet…
-
Formula Help Please!
Hi Community- I have a column that I want to say what phase a project is in based upon the criteria below 4 Possible Phases – “Strategy & Intake”, “Brief Finalization”, “Detailed Concepts”, “Production to Market” #1 “Strategy & Intake” – Milestone “BRIEF COMPLETED & APPROVED” is not checked and is not in the next 21 days…
-
Vlookup and matching
Good morning, First time using a Vlookup formula. All I am trying to do is cross reference employee numbers from one sheet to another. If the employee number exists in sheet A and is a match on sheet B, I want it to flag. I think I am over thinking it, Any help would be appreciated. In the screenshot, the formula will…
