-
VLOOKUP misalignment with column sort
hi, I have found misalignment of the data sort expectations between VLOOKUP function and Smartsheet's Column sort capability. It seems that when Column is being sorted, underscore symbol "_" is being put ahead of the letters, while when VLOOKUP is looking for the cell to match, it does expect "_" to be after the letters.…
-
Copying formula across columns
Hi, I'd like to copy a SUMIF formula across columns, where the only change in each would be to have the formula automatically update to match the new column name. Specifically, it would autmoatically change from the original colum =SUMIF(Personnel:Personnel, "Alison Michel", [Summer 2018 - Aug]:[Summer 2018 - Aug]) to…
-
Auto populate Assigned to based on reference
We have a project plan template and populate the 'assigned to' column with the role/title. Once I copy the new project plan template, how could I automatically update the 'assigned to' by task based on a role/name mapping. Could I have a project resources sheet with role and name and have the Project Plan tasks 'assigned…
-
Help with my formula
I am not the best at formulas and need some help. I cant seem to get my head around building formulas. Anyway can someone help please. I am trying to build a formula that will count all the true BOOLEAN in the children row and when it is greater than 4 return the a true outcome to the parent row. Hoopefully someone can…
-
"If clause" in Dependancies
Hi all, I am struggling to find a solution for this. I have 15 individual sheets for a project. One of the activities on sheet 2 will include a "yes/no" question. If yes, then sheet 3 needs to be completed. If no, then sheet 3 will not be necessary. I can't see an efficient solution for this. Any suggestions? Thanks!
-
RYG Ball Automation
Hello Community, How do I go about writing an IF function to get a particular cell to automatically show Green when the child rows turn Green individually? Basically, I would like to see the parent row update green without the need to do it manually each time I change the status of an individual cell. Thanks!
-
Count number of days between two dates and return the difference and if early or late?
Hi there Smartsheet community, I don't know if anyone can help me? I am trying to work out a formula to calculate the number of days between 2 dates, and also return if this was early, late or on-time. For example: Column A- Start date (20/06/2018) Column B - End date (31/05/2018) Column C - 20 days Early OR Column A-…
-
RYG Status Formula
We have two set of data that are required. Count column that is 0 until there is entry into one or all of the previous columns. This formula provides a count (this formula works fine) =IF(Series5 = 0, IF(COUNTIF([SKU 1]5:[SKU 15]5, "") = 0, 1, 0), 1) In the RYG column I have this Formula. =IF(Count5 = 0, "Green", IF(Count5…
-
COUNTIF Function
I'm trying to count everything in a Type column that = "Risk" that match a status of "Red" and "Yellow". How would I add "Yellow" to this statement? =COUNTIFS(Type:Type, "Risk", Status:Status, "Red")
-
IF function combined with Vlookup in 2 different smartsheets
Hello! I have another beginner question. Is it possible to combine an If conditional with a Vlookup? This is my scenario: I have 2 sheets: Summary and Form. Columns in each sheet are: Summary Sheet: -Column Name -Column Question #1 Form Sheet: -Column Name -Column Quarter -Column Question 1 The result that I need: I would…
