-
Sum duration with the result in hours
I try to sum children durations wich are in hours. It works with the formula "=SUM(CHILDREN())" but the result is always in days. I don't find how to change it. Thank's in advance. Ex :
-
Smartsheet not recognizing a number value
I have a sheet with item numbers and Dates when a purchase order is due. Some items have multiple purchase orders outstanding, so I have a MIN(COLLECT statement to find the earliest of the open PO dates for that item. What has me baffled is that for "Item" that has a six digit number, it doesn't return any value. If it has…
-
JOIN Muliple values dropdown menu
Hi, I have a simple JOIN formula to combine the cells on the right into a muli value dropdown menu column. However, for some reason, it will only show unique value and sometimes it wouldn't show it in order. Column "Join Formula" is a simple text/number column, with the same formula as "Join formula w/ muli dropdown". It…
-
I need help summing up the value of one column based on the status of another
I have two sheets I am using— one with all my data, reference points, and another with all my formulas. I want to sum up all the numbers in my 'Annual Revenue' column based on the Status column (completed, in progress, etc) of that same row. I want to use this formula in my other sheet which holds all formulas and data. i…
-
looking for help with a formula that uses one "text", and one "match" or "has" condition.
the closest I have gotten to getting some results is using: =IF(AND(CONTAINS("Q8", {Expenditure Report Collection Range1}), HAS({Expenditure Report Collection Range 2}, [Primary Column]@row)), "ok","missing") maybe I don't understand order of operations but it's giving me a "ok" on a cell that should be missing. I need to…
-
AutoNumber Column Based on Another Column
I have tried to follow other threads asking similar questions, but I'll admit, I'm lost and any attempt at following those formulas has not resulted in what I need! We currently have a request form and have each submission set to assign an auto number to the request. Which is ok, but we really don't want them to be…
-
Rank Top 5 Versions
Hi, I need assistance in finding the top 10 major releases. I have 8 sheets with the same structure. Each sheet represents data for a specific quarter, such as 23Q1, 23Q2, and so on, up to 24Q4. Each row represents an open case with case details. Each sheet has 25 columns and 10,000 to 17,000 rows of data. Example of such…
-
Dashboard Template with help columns - please help
Hi all, I am attempting to use this dashboard template, https://app.smartsheet.com/r/template-gallery/templates/3c06021d-a78a-4203-a8ae-1282c8dc1555/Dynamic-Dashboard-with-Form-Filter?tg-locale=en_US. Note this includes the dummy data that comes with the template and I will be replacing it with my own info. There appear to…
-
How to calculate weeknumber for a financial year
Hi, I need to calculate the week number of dates according to a fiscal year starting April first 2024 and ending 31 March 2025. THe formula weeknumber gives me the week numbers based on a year starting from January First and ending 31 December 2024. Thank you for your help
-
Adding 1 more condition to AVG () with Collect() formula
I have successfully used the below to average the aging for help tickets that were reported between 2 dates. I need to add one more condition, so that it only provides the average if the severity of that ticket is Urgent or High (using @row). I cannot figure out where/how to add this third condition. =AVG(COLLECT({Closed…