-
Calculate Expected completion %
I have added a column to my project plan template to calculate expected completion %. I want to the parent level rows to calculate an average based on the children. I'm thinking I need to add an IFERROR... =IF(COUNT(CHILDREN()) > 0, AVG(CHILDREN()), IF(Start@row < Today@row, MIN((Today@row - Start@row) / (Finish@row -…
-
Need help with a formula to create a pick list from a column on another sheet
Hi, We have a Project Intake Sheet that lists the Clients, the Status (active, etc) and the PM's working with each client. When filling out the Issue/Risk log, I'd like the values which appear in the cells in the client column to be presented as a single option pick list and be limited to only the active projects which the…
-
Possible to have two IFERROR values?
I have an IFERROR formula that is working correctly., However, I was wondering if it was possible to add an additional IFERROR option. So, for instance, This formula works perfectly: =IFERROR(INDEX({EventTitle}, MATCH([WE ID#]@row, {ID}, 0)), INDEX({EventTitleComp}, MATCH([WE ID#]@row, {IDComp}, 0))) My only problem is…
-
Formula to reverse order of column
Hi, Is there a formula in smartsheet to reverse/flip the order of a column from A B C to C B A This can be done in excel using an INDEX and ROWS function: =INDEX($A$2:$A$80,ROWS(A2:$A$80)) however it doesn't seem that SmartSheet has a ROWS function. Thanks! -Junn
-
Countif status is "In Work" and Multiple choice contains
Hello All, I am trying to establish a Countifs formula that first checks status, then looks for a specific multiple choice option. Is this possible? =COUNTIFS({AD-CVT Disc Status}, "In Work"), ({Above Findings}, (CONTAINS(Primary Column]@row, @cell)) Any help is appreciated! Thank you.
-
How I find the first column?
I have a range of columns with 14 milestones. If the milestone reached, then it will be delete and the cell is blank. Now I would know, in which column are the first date. As result I would need the column-name, with the first date or the number of column, counted from the first column of the range. Any ideas, which…
-
Status circle and IF function based on dates
Not sure if this can even be done, didn't find a clear answer in a search. I want a status column that automatically chooses the colored circle based on the dates of "Potential Start" column already set up. I want it to show the Green light if the P.S. date is more than a week out Yellow if it is less than a week but still…
-
Auto Command based on RAG color displayed
Hello, I want an automated response based on RAG colors displayed. This perhaps by creating a nested formulla.-see attached. If ResusTrolley/Cart is green, then comments should be "Excellent", otherwise "Needs updating". If Eyewash Station is green, then comments should be "Excellent", otherwise, "Needs updating" Can any…
-
Option to check parent rows only
Hello, I am creating a checkbox in a column containing parent and child rows. I do not want the checkboxes for the children row to be an option. Only for the parent rows to be able to be checked. How can I action this? Any help would be appreciated.
-
If Blank formula help
=IF([Accounts Per Day w/o TOOQL]170 < [Accounts Per Day w/o TOOQL]@row, "Up", IF([Accounts Per Day w/o TOOQL]170 > [Accounts Per Day w/o TOOQL]@row, "Down")) I want to add if "Accounts Per Day w/o TOOQL" @ Row is blank, leave blank or sideways arrow is fine if i have to choose something.