-
Selective Counter Column
Hello Everyone, For the purpose of tiered pricing, I am trying to add a column to a sheet that tracks the instance number of a row with a particular property. For example: I add an row/item, enter 'medium' in the size column, and the formula in question picks up that this is the third 'medium' item in the sheet, counting…
-
INDEX/MATCH COLLECT #UNPARSEABLE
Hi Smartsheet Team! I would love some help. We have a sheet[TESTING] that has a list of our 900 stores. As these stores are closing/reopening they are submitting forms that get added to the bottom of TESTING. What we want is to be able to constantly have the information from the forms being submitted pulled up into the…
-
formulas not copying down
I run into issues with my sheets where the formulas do not copy down when new rows are entered. I understand that the new row cannot be blank and have clarified that to the users, but this is going to be a recurring maintenance issue. I have a fairly simple build where I am tracking billable time for a team. We are…
-
countifs formula works in cell but not in sheet summary
Hi, All I have this countifs formula - '=COUNTIFS([Point SysName]:[Point SysName], <>"", [Cable Roughed In?]:[Cable Roughed In?], 1)'. When I put in in a cell, it works. But when I put in a sheet summary field, it comes up with an error message of '#UNPARSEABLE'. In the attached photo, the number '2' is the result I am…
-
Running a report with multiple sheets, columns not populating
Hello, I am attempting to run a report with multiple sheets and/or a workspace (I have tried it both ways) the criteria seems to work fine but when I attempt to show a column from one of the other worksheets it does not populate. Any suggestions??
-
Employee Reviews - Averaging scores for different criterea
Been playing around with a few index/match formulas but getting a bit complicated..🤯 To explain: Need to add numeric values to each dropdown to give scores to each critera Then search for each Reviewer that reviewed each employee and add all scores for each critera Finally, average the score =AVG(CHILDREN()) Went ahead and…
-
Red Yellow Green Gray
Hi Experts :), I need help with my formula. Principles I am trying to achieve are: if Min Variance column is blank AND the Minister Due Date is past today by less than 2 days, OR the Min Variance@row is Less than 2, then flag Yellow. If the Min Variance column is blank, AND the Minister Due Date is past today by more than…
-
INDEX Function to lookup a value from another sheet
I need to add a "Need By" date to a sheet based on infomation and criteria from another sheet. The working sheet has the following relevant columns: Module (an alphanumeric identifier) Need By Date (The column I need to populate) The Target Sheet {LNG - Project Tracker 1} has the following relevant columns: Module Number…
-
Invalid operation using index & collect function
Hi Smartsheet Community, I'm trying to perform cross-sheet references, specifically pulling the names of accounts from a deal tracker sheet based on specific employee names, using both the 'index' and 'collect' function, with one 'if' statement: =IF({Account Status in deal tracker} = "Live", INDEX(COLLECT({Account Name…
-
Tasks not started
i'm trying to calculate the number of tasks not started (out of the box functionality for the accelerator that I had to repair) I'm trying to look at those that are tasks (so non-tasks are not checked), Percent complete is 0, and that have a task associated with them (so we aren't counting blanks). -Project Schedule Range…
