-
Populating the Parent Row from Another Sheet
I have a spreadsheet that contains all of the inventory information for a lot of products. These products are broken down into categories. For example, shoes (a parent row) would have the child rows of sneakers, heels, slippers. I am receiving orders from products onto another spreadsheet via a form. From the form, I am…
-
Formula to get group from belonged user
Since the groups are the only way to categorize users, we use groups as "departments". I'd like a formula to get the name of the group where each user belong to. thanks
-
Combining two formulas to filter data
I need to create a formula to count any lines that reference "GEMS Point", that will further filter only for any references within a given month. I have the following two formulas that are working perfectly: Formula for total by GEMS Point: =COUNTIFS({GEMS Point}, [Primary Column]@row) Formula for January programs…
-
#INCORRECT ARGUMENT SET on Index/Collect Formula
I'm building a dynamic dashboard with multiple filters. I'm making a Index/Collect formula that can read values on a source sheet based on the values selected via the filters. This formula should work and I've seen it work on other sheets that Pro-desk helped with, and they gave me, but for some reason, I'm getting a…
-
Text Join Formula
Hi there, I created this formula: =JOIN(Course@row) + " " + [Course Date]@row that worked but I need assistance on changing the order of it. Course Date with Parentheses around the date and Couse Name Formula that I have: =JOIN(" ", "(" + [Course Date]@row + ")", [Course]@row) that will not work Example what I want:…
-
If Status = Resolved, can a field be blank, else display a calculated number of days?
I want to track "# Days from Submission, but still Open", and also track "# of Days from Submission to Resolved". Currently the formula I have listed in "# Days from Submission" allows the number to get larger every day, even once the "Status" is "Resolved". Looking for advice on how best to handle this; at a minimum, can…
-
How to COUNTIFS with DISTINCT dates and other range/criteria?
Hi, I am trying to write a COUNTIFS formula, taking into consideration of X criteria for a range of cells in addition to DISTINCT dates within Y range. Can anyone share any insight how to write this in a formula statement? I'll provide an example below. I have a list entries in Smartsheet. They have dates associated with…
-
When cell is updated to new value it updates past and present cell values in target sheet
We have a sheet similar to a price sheet that populates a target sheet via index/match formula. Stakeholders submit orders via a SmartSheet form. However, I don't know how to update orders in the future not in the past. Past order should still be the same value / cost. Thank you in advance for your help. Cathy
-
Formulas not updating when new data is added to underlying sheet
When new data is added or updated to the underlying sheet, the formulas are not recalculating. I run an upload workflow each morning and want the metrics sheet below to recalculate based on the updated report I attach. I have to manually re-enter the formula to get an updated metric. The counts, averages and formulas using…
-
How do I calculate the average time a representative takes to resolve a call per month?
I have created a weekly intake form that managers complete documenting how many calls their employee handled as well as the average length they were on the calls. I am creating a roll-up report where I need to calculate the monthly average length of time it took each employee to handle the call. This screenshot show how…