-
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…
-
AverageIF
I am trying to get the average number of days to fill a position, the formula I am using is pulling data from my worksheet for the Position type, date range, and days to fill. With my formula below I am getting an Incorrect Argument. I think it has to do with the bolded portion of the formula. =AVERAGEIF({Time to Fill -…
-
Dashboard Viewer Filter
I attended Engage last year and a new advanced option was announced called "Dashboard Viewer." I can not find this on any of my dashboards. Is there anyway I can filter the data on by dashboard by different users viewing it? Thank you :)
