-
Adapting an Existing Formula
Hi, I would like to adjust the formula that comes with the Project Management Office Templates. The Smartsheets template comes with this formula in the "Portfolio Metrics" sheets in the Total column and on the In Progress row. =COUNT(COLLECT({Project ID}, {Project Status}, $Label@row)). I would like to change Project ID to…
-
Split Multiple Selections In Single Form Into Individual Rows (Core Product)
There have been a number of people asking how to make multiple selections in a single form and then have those selections broken down into individual rows, and the previous answer was always to use a 3rd party app, a premium add-on, or the API. Below is a set of detailed instructions on how to accomplish this within the…
-
Free Smartsheet Webinar Series by DigitalRadius
I wanted to share an exciting resource that I think a lot of you will find valuable! Our Customer Success team here at DigitalRadius is hosting a Free Smartsheet Webinar Series now through the end of the year, designed to help you unlock the full potential of the Smartsheet platform. It starts tomorrow! Here’s what’s…
-
Pulling the most recent entry into a report
Hi, I want to create a report that will have the most recent Project Health from a group of Project Update sheets. On each Project Update sheet, I created a help column to show the Max date = 1. I think this will work to get to the most recent update with the most recent Project Health, but I don't know how to construct…
-
V Lookup formula for importing Contact List broke and I don't know why.
So I have a reference sheet of contacts and their assignments. I made a different sheet to assign tasks as they come in and set up an equation to look up and auto assign. It looks like: =VLOOKUP([Rule Number]@row, {Committee Range}, 2, false) So when a task came in and it matched the rule, it would assign the person in the…
-
Too many Cell References Error
So i am making a sheet to keep track of different devices i mangage. While doing this i ended up with a lot of duplicate columns (Ex: Description column and another column named [DESCRIPTION] with the formula "=Description@row") Since getting the too many cell references error i deleted about half of the columns i had and…
-
If Match Check Box
How do I write a formula to check a box next to an ID Number if that same ID Number is also present in another column? So Column 1 is ID Number to complete and Column 2 is ID Number completed list. Thanks in advance!
-
Column Formula for only Parent Rows
We have a few sheets that use different formulas for both Parent & Children rows. Is there currently anyway reference whether a row is a parent or a child row so that we can run different formulas in the same column while using the column formula functionality? Thank you!
-
Issues with Numbering Children (Child 1, Child 2, etc.)
Hi! I am trying to implement a column formula in Smartsheet that assigns an ordinal number to each of the children in a sheet. For example, the first child would get a "1", the second child a "2", and so on. I've tried several options, and the one I liked the most is the following: Create an auxiliary column with a "1"…
-
Index/Collect from Descendants
In this sheet, I have a column [Groups] which is a parent column to multiple "Groups", each of which is a parent column itself to tasks associated with each group. I need help putting a formula in [Start Date] of the parent row that would give me the very 1st value from [Date] column that is a Descendant of [Groups]@row…
