-
Column formula for checking off a parent task when its children are checked
I am looking for a formula to check "Done" when a task's children are all checked "Done." Importantly, I would like this to be a column formula. What would be the syntax to ask a formula to exclude tasks that have no children themselves? Here's the formula we have been using, which only works when limited to parent rows,…
-
INDEX/MATCH and INDEX/COLLECT Issues
Hi, I am essentially trying to combine the two below formulas into one. I keep seeing that I should be able to use a COLLECT formula instead of MATCH to have two criteria, but whatever I do it isn't working. The formulas: =IF(WFX@row <> INDEX(WFX:WFX, MATCH(Quarter@row, Quarter:Quarter, 0)), "Yes", "Applied") =IF(WFX@row =…
-
Can Smartsheet automatically push a date on to a Thursday?
Hello. I thought I’d found the answer to this in a forum a while back, but the answer on there didn’t work for me when I tried it – I’d like to know if there’s a code/formula for Smartsheet to check whether an End Date (publication date) falls on a Thursday and for Smartsheet to automatically move the date along to the…
-
Using Parent Rows in Reference Another Sheet Formula
I'm attempting to calculate the total number of pediatric calls by county using this formula all referencing another sheet: =SUMIF(PARENT({MAHEC County}, "Buncombe"), {Pediatric Calls}) However, it is not working. Any suggestions?
-
AND(Contains(...), Contains(...)) Functioning
Hi all! I have a question I have not been able to fully decipher with the documentation. I have been trying to identify if a certain combination of values in 2 columns appear in 2 other columns from another sheet. (Let's say I search value A in "Alphabet" column; and value 1 in "Order" column: I want to find out if the 2…
-
Is it possible to change the Source Sheet from Reference instead of individual references ?
Dear Smart Team, How can we modify the Source Sheet name from the Reference instead of modifying individual references. Scenario. I have created more than 50 References use this reference in different formulas. For Example Question and Answer. Reference "Ans 1" for Answer 1 and "Ans 2" for Answer 1 and so on, till 50th…
-
SumIfs with multiple values from same column
I'm attempting to Sum $ based on several statuses in the Status Column, but can't figure out how to use multiple values. I successfully used the below to sum for one status, but need to add 3 more statuses "Pending Mail Merge" , "Awaiting Calculation" and "Payment Received" =SUMIFS([Amount of Bonus Owed to Company…
-
VLOOKUP not working in a specific sheet of destination
Hi all. I am trying to do a simple VLOOKUP calling to a sheet as simple as the following one, wanting to get out of the Worker the Manager in the next column Nonetheless, I am puzzled. When I open a new blank sheet and do the changes, the VLOOKUPS works perfectly, but in the following sheet, with exact same formula and…
-
Combining selected cells into one cell ignoring blanks?
Hello all, I am trying to combine cell into one cell and I have found a couple other community posts covering this issue. The only problem is that their solution only applies if you are trying to collect the entire row, I need specific row. Originally, I did this just by using JOIN and then selecting each cell, separated…
-
Color code drop-down lists in calendar view
Hi all, I am new to Smartsheet and I hope you can help me with a question. This is my current sheet set up to keep track of the events organised by my team organised by country. Each country is a Parent row and child rows are the events' names. I would like to format it in such a way that if the parent row is color coded…
