-
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…
-
Using values from a cell in a previous row and circular reference issues
I am trying to create a “simple” sheet to track tasks and projected completions based on the task priority with the sheet sorted by priority. The intent is to have the next priority start after the previous is completed. From other help questions I was able to determine that I could get start date from the previous…
-
How to count a value with multiple selections
I'm trying to count a value with multiple selections, but I can't seem to get the correct answer here's the formula I've tried but none of it works. =COUNTIFS([Resolution Action Taken]:[Resolution Action Taken], "Conversation with Employee", [Ticket Type]:[Ticket Type], "Client Service Escalation") =COUNTIFS([Ticket…
-
Date + 7 Formula, in cells, in a row
Hello, I'm hoping someone can provide a quick answer or solution to doing what is such a simple task in excel in Smartsheet. I have read through numerous posts and watched videos to hopefully solve this but I cannot find a clear cut answer. I understand that Smartsheet dates are best used in a column for formulas. However,…
-
Count Number of Tasks
Hi, I am trying to build some dashboards widgets that sum up the number of tasks in a list. The list includes multiple "parent" type rows, but I only want to count the child fields. I created a 'heirarchy' class, but the problem is I need to sum both the 1s and 2s based the various categories. Also - how do I actually get…
-
How to Step Rounding Percentage
Below is a very basic formula actual/workset a to get the %achieved. You can see that the two calculations are off one should be 33%, the other 20% What is the best way to show the actual value, not the rounded value? Thanks!
-
Index Collect and Multiple Output Values
Hi All, I have multiple things going on and am hoping I can find one formula to clean things up for my team. Basically, I have the below list as a helper sheet. Then, i have a form that our customers can complete. They can select from the list that is on the left of the example below and they can select multiple options…
-
Issue with text parsing on date/time populated by automation
I'm having an issue where I have a created date column, then a date column that referenced the created date column and uses text parsing to remove the time. formula below: =DATE(VALUE(20 + MID([Issue Opened Date]@row, 7, 2)), VALUE(LEFT([Issue Opened Date]@row, 2)), VALUE(MID([Issue Opened Date]@row, 4, 2))) This functions…
-
Need Help Calculating Work Day Differance Between 2 dates.
Hello All So I have 2 column I am trying to calculate the work day differance. Pch Final Insp live sc and Pch Final Insp baseline 115. Problem I am having. If the dates are the same it shows a 1. I want it to show a 0. if the days are one day ahead or one day behind it shows a -2 or 2. It should show a -1 or 1. Here is the…
-
Formatting to color code unique differing values?
HI - looking to see if I can alternate color coding of rows using conditional formatting to make it easier to read. For example, the first set of items (sample size) would be gray, then the next white then staffing training back to gray. They are variable numbers and rows can be added to a group at any point
