-
Countifs Name reference
We are working on a formula where we are needing the counts of two names in a column. So if the range column we are pulling from has both John Doe and Jane-Marie Doe, we want the count of how many times that occurs. This is the formula we have and it is not working: =COUNTIFS([{A Great Place to Work Range 4}]:[{A Great…
-
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