-
Absolute reference
I want to use absolute reference for a cell. However, when I select the cell, I always get the @ row at the end. For example, when I select the cell [Text Text], I get [Text Text]@row. Do I have to always manually specify the cell number when I want to use absolute reference?
-
Why is this formula not converting to a column formula?
Hi, I have set up this formula and am trying to convert to a column formula but it tells me there is an error and it won't do it. How do I change it so that it works? Also would there be a more efficient way of writing this formula? Thanks! =IF([Month No]@row = 1, [PO #]$1, IF([Month No]@row = 2, [PO #]$1, IF([Month…
-
Sheet Summary Formula for Number of Tasks Complete (Not Started, On Hold and In Progress)
Looking to find a formula for number of tasks in each status- I have this so far but I'm getting the #UNPARSEABLE error. Please help =COUNTIFS([Status]:[Status], CONTAINS("Complete" @cell)", [%Complete]: [%Complete], 1)
-
Formula
Hi everyone, I have a form going were people add rankings. I am trying to compare in a seperate sheet the latest two entries. Is there a way that I can tell smartsheets to always pick the lates two entries from another sheet? I know how to pick the latest but I am not sure about how to pick the two most recent ones.
-
Ancesstors
I can use the below formula to get the ancesstors + task name JOIN(ANCESTORS([Task Name]@row), " | ") + " | " + [Task Name]@row This will return to me: Parent 1>Parent 2> Parent 3> Task 1 I'd like it to return the reverse order: Task 1> Parent 3>Parent2>Parent 1
-
Sheet Summary - Show completed tasks and status
Below is an example of one of my sheets in smart sheet I would like to add a sheet summary that : Shows the status of the overall project automatically ( in Green/Yello or Red) by calculation, as in looks to see if the status of the items that were supposed to be finished in the last two weeks are Done and if the status of…
-
Counting number of times a deadline is missed
I need a formula for a sheet summary that I just cant wrap my head around, might even be two formulas working together...Maybe I am over thinking it. I need a formula to look at a "date1" column and a "date2" column on a sheet and then I need it to count the number of times the difference between those two dates is more…
-
Parents and Children relationships
I have the following items I need help with: 1) I would like my children rows to automatically display Parent | Task Name For example in this configuration: Parent 1 Child 1 Child 2 I want to see below instead of above Parent 1 Parent 1 | Child 1 Parent 1 | Child 2 So I need to apply a column formula that would do this.…
-
How to record monthly changes in sheet?
So I am trying to get a formula to return a count of the number of cells that match but only if another column that records a date is within the last 30 days. I tried with reports but the issue is they don't display right if I try to send updates in any way besides a link (and I need it to run monthly, weekly, etc.) I felt…
-
Averaging Health Status for Parent Rows based on Average of Children Rows in RYG.
Hi everyone, I am looking to find the best formula to give me the average health status in RYG for the parent rows (#2). I have tried IF formulas but keep getting parsed errors. Please help. Also looking to get the formula to the sub row (#1- where the picture says strategy session or AI POD etc) to the parent as well. Any…