-
How to get an average of multiple symbols (harvey balls) on a single row?
Hi, I have a form that once completed populates a sheet. The form has about 100 items. The idea is that 100 items represent 5 categories. For each individual that completes the form I need to provide an average from the 100 responses that correlate to each category. I have the columns next to each so I can use the "range"…
-
Dynamic Array Formula Help
GOAL: Create the most efficient formula that can drag across from Column "1" Row "2"and down as project budgets are activated (by form submission adding rows to the bottom of the sheet) and subsequently drawn down. Target Sheet has 60 project budget columns to the right of Project Kickoff, most blank, to allow additional…
-
Counting value repeats since last distinct value
Hi Smartsheet experts! I'm trying to accomplish something like the above, where I count the number of repeats of one value in a column, but that count resets when the value changes and resets to 1 if the same name appears later. This is to consolidate an order form where users can order different numbers of items- it's…
-
Capture a “Last Updated Timestamp” (Date + Time) for Specific Cells/Columns (Lockable)
It would be valuable to support a configuration that allows users to record the exact timestamp (date + time) when a specific column/cell is edited, and to save or lock that recorded value so it does not change with subsequent updates. While Smartsheet automation can capture dates, many workflows require date and time…
-
% calculation for parent overview
In the above image the green is the parent line, where some are calculating the child line %'s below, however in the lower half of the image it's not doing so. Any suggestions please? Thanks!
-
INDEX/MATCH ERRORS
I have used the index/match formula successfully , but in my current project, for some reason it isn't working. I have my two sheets (Open Adp) and (A/N Referrals). In Open Adp, there is a Case ID and then a person's name associated with that ID. I'm trying to have the person's name from Open Adp sheet be pulled over into…
-
How do you create a dynamic list of unique values from multiple sheets?
I am trying to create a "level of effort" calculation where we compare the count of bidded, lost, and awarded projects against a specific criteria, which is often a dropdown column in the source sheet. I have tried using JOIN, COLLECT, and INDEX from at least a dozen posts in the Community but nothing has worked to date.…
-
COUNTIFS Formula Based on Status and Due Date
I'm looking to create a formula that will count the number of overdue tasks. This is based on the "assigned to", "status" and "due date". My current formula is =COUNTIFS({[Sheet Name]}, <TODAY(), {[Sheet Name]}, ="[Assigned To]"). However, this is pulling tasks that are due in the past, but are completed.
-
How do I list all predecessors (direct and indirect) for a given row?
Does SmartSheet have a way to list out all of the predecessor rows that feed into a given row? For Row 22 in the example below, I would like the formula to return the values 20, 19, 18, 17, & 16. Either that, or I would be looking for a list of all direct and indirect successors to a given row. Either would get me where I…
-
UPDATE - Health and Wellness Solution
Here is what I have built out so far for my Health and Wellness Solution. Please note some information has been redacted, including my Forms Dashboard which is where I go to log most of my entries, it is more for me to see, it's not as pretty as these are. I'm a dork and record many things just for the fun of it. I started…