-
#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…
-
Vacation Tracker - half day entry requirement
Hi everyone, I found a great youtube video that helped me build a vacation tracker for my business. Only problem is the tracker covers only full day vacation requests. Could any of our great experts help me to amend the below formula to incorporate a half day vacation request? I guess I would need to add a column into the…
-
Task Health: formula dependents on Creation Date
Hello there, I need to automate the Task Health column basing on the following criteria: Blue: creation date is in the last 3 months Green: creation date is between the last 3 and 6 months Yellow: creation date is between the last 6 and 9 months Red: creation date is more than 9 months old Thanks for your help
-
AI Access
Hi, The latest update on innovations mentioned that the first AI feature, AI formulas and generative content, is available now to EAP members. I can't find any information about how to use this, is there any more information on how to get started as an EAP member? Thanks, Madeline
