-
Using COUNT and CHILDREN functions to return non-blank rows under parent row of a different sheet
Hi Smartsheet Community, I need a formula which will allow me to look up the number of non-blank rows under a parent row from another sheet and return the value. As an example I've attached a screenshot of my reference sheet where I am trying to count the non-blank rows under the parent row "Over 50%", some of the…
-
Accessing Children of Children if it meets certain Conditions
Hi, I'm having trouble getting a formula to help me tally info for a dashboard. I have a sheet that is tracking the requirements of several capabilities of a system that we're migrating. The Column called Core Capabilities, has 4 children (Categories); Critical, High, Medium, Low. Each of those categories has a range of…
-
Auto Date Calculation
Hi, I have 3 column's - Days, Start Date, Completion Date. I would like to enter days and start date, and let Completion date auto calculate. So for example if I enter 30 in days and 6/14 in Start Date, I would like Completion Date auto calculate to 7/14. Any tips on the right formula for this? Thanks!
-
How to export the relation of a table: attachment and line/raw uploaded to
I can export table and all the attachments within, or i can do a backup of the whole file with all attachments from the home (list)overview, but in both ways, i can't find the information in which line the attachment was uploaded to. But this is important to me since i have 122 attachments per sheet! Smartsheet table and…
-
Build Gantt Chart based on JIRA User Stories Story Points estimations
User story in Jira are estimated in Story Points (0.5, 1, 2, 3, 5, 8, 13, 21...) where each story point can be mapped to ideal days range such as a 0.5 story point = 1d, 1 story point: =2d 2 story points = 3d 3 story points = 5d ... Theoretically it is possible to build a gantt chart of the N user stories as follow User…
-
Fill across not working as expected?
Wondering if anybody else is experiencing this - I have performed this scenario hundreds of times without issue so wondering what's up! I have a formula based on full Column:Column ranges. The criteria ranges are set with $, the range to sum is not. When I click the + symbol at the bottom right of the cell and drag it to…
-
Netdays Negative Return
Hi All! I'm running into a quirk when using the netdays formula."Create Date" is a system generated column used for the start date, and "Resolution Date" is the end date. When I have a record where the resolution date is the same as the startdate, I'm getting a -2 for the netdays between these values. Any idea what's going…
-
Alerts and Actions not working
Hi, I have a sheet where the RYGG is automated based on the due date (overdue=red, due date +2=yellow, the rest=green). I then set up the alerts ("Send a notification") so when the status turns yellow one email goes out, and when it turns red, another one gets sent out. I've played around with this for a few days. I have…
-
When to use @ROW
Is it best to use @ROW whenever possible over the actual row number? Can @ROW only be used in simple formulas like =[Column1]@ROW? Or can it also be used in more complex formulas like =[Colmn1]@ROW+[Colmn2]@ROW+[Colmn3]@ROW
-
Total Count for Specific Date Range from another Sheet
I am referencing a seperate SmartSheet that I have Admin rights on. I want to count the number of items listed within each specific date range was work by. I would like to then find out how many of those items have been completed. I have been trying to work with the following formula but it keeps bring back "0".…