-
Link matching cells
Hi, Is there a possibility in Smartsheet to somehow link cells that have the same text in the same sheet? For example, I already have a cell in row 89 with the text - "PAC289" and a new row entry with the same text has been inputted into the same sheet by a user. Any way of linking / higlighting the cells will do! I will…
-
How to alert someone when sheet level approval share.
I am working in workflow design. need condition that send alter notification only if person approved all sheet rows data.. any sheet level approval option are available in smartsheet ?
-
Formula to uncheck one column when another column is checked
I have a checkbox column that is used when a project and any of it's tasks are Active. I have another checkbox column that is used when a project and/or any of it's tasks are Done. I have another column that will generate the date when the Done box is checked and also will automatically change the percent complete to 100%.…
-
Combining Dates For a "Sort By Date"
I have an interesting scenario where I am combining 3 SmartSheets into 1, and this happens in three phases: First, someone initiates a request by submitting a request through a form into the first Smart Sheet. When they submit the request, the request is simultaneously copied over to a "Master Sheet." When it does this, it…
-
#incorrect argument set for a countif statement with multiple references
I'm trying to count check boxes if the % complete is <100. I can COUNTIF the check boxes on their own, but when I add the % complete reference, I get the incorrect argument set error. Any ideas? Here's the formula: =COUNTIF({Portfolio_Rollup}, 1, {Completion_Percentage}, <100)
-
Managing task and % complete column
In a project I have task for doing, but on the way, some tasks will be cancelled for any reason: the client suspended, its not necessary now or for any reason. My question is, I need put on the % complete cell a 100% completed?? for me its not logical to do that but If I dont do it the average on my principal row will be…
-
Contains Formula
I currently have a formula that looks to see if a specific phrase is contained within a range of cells: =IF(CONTAINS("Apple", Fruit1:Test1), "Fruit") Is there a way to have the formula look for another phrase as well? ie) =IF(CONTAINS("Apple" or "Orange", Fruit1:Test1), "Fruit") or something along those lines?
-
I need help figuring out how to count the number of children rows that have a certain status.
I can't seem to figure out how to get this formula to count only the children rows that have a certain status. For example: I want to get a count of the status of Green, Yellow, and Red of only the children rows of Parent row SWAR Caribbean Distributors in the column Dealer Legal Name. The children of the parent row SWAR…
-
COUNTIF CHILDREN, Numbering Each Child
I am looking to create a count formula that counts only the Children and numbers them consecutively. I can then use an embedded IF statement to calculate specific hours attributed to each Child. This simple formula, =COUNTIF(CHILDREN(), 0) outputs the number of Children in the Parent cell, but leaves a "0" in each Child…
-
Feature Enhancement Request
I would like to be able to append/adjust actively sorted values in a range. In other words to be able to handle data more like matrix formulas in excel. Currently this is done with collect, but there isn't a way to change the values being filtered individually. To that end I propose a =collecta() formula. =COLLECTA({Return…