-
Cross Sheet Formula For Averaging Total Turn Around Time
I’m looking for a cross-sheet formula in Smartsheet to calculate the average Turn Around Time (TAT) by specific Site Numbers. Source sheet details: Site Number (text/number) Turn Around Time (number; measured in days) Target sheet details: I have a row per site and want a formula in the Avg TAT column that returns the…
-
Counting Distinct Items in Sheet1 from Sheet2
I have a counting formula that's working in Sheet1. When I try to use that same formula in Sheet2 to pull the data from Sheet1, I get an UNPARSABLE error. What am I doing wrong? Original formula (in Sheet1): =COUNT(DISTINCT(COLLECT([Department]:[Department], [StartDate]:[StartDate], >=DATE(2025, 7, 1), [Status]:[Status],…
-
What do you use for your Sheet Reference Name?
Do you use the standard {Sheet Name - Column Name} ? Or do use a simple name that can be easily identified? Or Do you use abbreviations? Im curious and would like to know your approach, Im hoping I could learn a lot from your experience.
-
Help Needed
Hi All, I am trying to create a formula to work out the number of days ( Helper V1 ) between the VISIT 1 and VISIT 2 days column. Any thoughts would be greatly appreciated Thanks
-
INDEX formula to get the text in the next row in a different column
I need the formula to get the text from the next row in a specified column. I am creating the formula in row 2 in a column named 'Next' and want it to bring back the data from column 'Test' in row 3. This is what I have tried so far but getting #unparseable error. =INDEX(Test:Test, row() , +1) =INDEX([Test]:[Test], row() ,…
-
INDEX - Collect question
Hi there, I have a project where in the project plan, based on the start date selected for a task, I'd like Smartsheet to reference another sheet (which is the table of Sprint, Start Date, Proposed Completion Date, Sprint Label) and populate the Sprint Column with the correct Sprint Label). So the formular should check…
-
Additional Condition (Formula)
I have a formula that is currently working (see below); I need to add a condition, from a specific Column (Study Status)-that if it equals a particular choice ("Study Ongoing - Follow up"), that it doesn't even bother looking at this formula and automatically turns the FLAG off. Furthermore, I'll need to have several…
-
Calculating net hours
I've found Paul Newcome's mega post on calculating hours and from that have successfully created the total number of hours worked. But I am trying to have it calculate net hours worked after taking away any unpaid break. Breaks will be 30 mins or 60 mins. I've seen other posts from people asking about it but haven't seen…
-
JOIN-COLLECT and Contact
Hello, I am trying to use JOIN-COLLECT to populate a cell with a contact by pulling from another sheet. However, when I use this formula it populates the cell with the name of the contact as a text string, but does not populate the cell with the contact itself. Both the column of cells being populated and the column the…
-
Multiselect Dashboard Widget HELP!
Hello! I am attempting to create a dashboard widget that shows me how much budget we are spending in each segment, and in what category. The source sheet contains these columns… "Budget" - text/number column "Category" - dropdown list (restricted to list values only) "Segment" - dropdown list (allows multiple values per…