-
Moving singular cell data into a sheet from a master sheet with autonomy?
I am sure this has been asked before, but I have scoured many forums and attempted many solutions but to no avail. My issue: I have a sheet (let's call it master) that holds metadata. I also have another sheet (let's call it Department) that relies on a single piece of metadata from Master, but also requires the ability to…
-
Recording Week Tasks Were Completed
Hi all! I'm back with an old problem that rattled me a few months ago. Basically, when a task is completed, its date of completion is saved. For the sake of being able to a process this data in a more comprehensive manner, we want to take that date, and assign it a "weekOfCompletion". Another note, is that the weeks here…
-
How do i create a formula to source information from another sheet with multiple countifs?
I am trying to setup an automated metrics sheet from many other sheets and I am stuck on the very first "reference another sheet" formula due to the conditions (countifs) that I'm trying to get it to pick up. Here's the example: The metric sheet is trying to count KPI's from other sheets, for this particular instance a…
-
Requesting assistance with multipart COUNTIFS formula
Hi all, My team and I currently use Smartsheet to track monthly referral information. At the beginning of each month, we are looking to obtain the number of referrals received for the prior month (ex: because it is January, we want to capture data from December). Here is what we are trying to track: How many "SEN"…
-
Why does my Metrics constantly stop calculating correctly?
I've been making a "Metrics" sheet for some time now, and in the beginning everything was calculating fine. But it seems to be when I add more "data tables" if you will, or more metrics, some tables stop calculating correctly. Here is what my sheet looks like for a better understanding So, the first few-ish sections will…
-
Dual Horizontal Split Column Option
I know this probably isn't possible but I'll ask anyway. :) Is it possible to create a horizontal split on a sheet where the "top" split would have different sets of columns than the "bottom" split? It would be like having two primary rows on a single sheet. This would be like having two sheets in one for more complete…
-
Quick Link or Chart for Capacity Limits
I am frequently having to refresh my memory of capcity limits for cells in a sheet, workflows per sheet, etc. It would a great tool to have a quick link to a chart in Help or Community that is quicker to find or easily searchable within Help. Thanks!
-
Pro/Cons: Teams using Dynamic View vs the Sheet itself
I am looking for your thoughts about teams using Dynamic View vs going directly to the sheet itself to add new line items and editing. Reason for the asking is that I have some teams that are used to working with Excel to manage their list of activities and the quick copy/paste abilities you have there. In Dynamic View,…
-
Modified =SUM(CHILDREN()) Formula needed
Dear All, I am struggling to modify this formula: =SUM(CHILDREN(Points@row)) Working in agile development, my "Points" column contains development points needed to complete a task. Overall I have 4 hierarchy levels: Task, User Story, Epic, Initiative. I would like to display the sum of task points on the User Story line…
-
Max Formula - related question
Hi I have a table for our Product Development Items. In it I track 3 levels of items: Initiative, Epic, User Story. In a separate column I assign Quarters, e.g. Q1'23, Q2'23, or H1'24 or 2025. For the Parent level I would love to be able to identify which of those is the farthest out quarter. Is this possible? Best, Sylvia…