-
Forms Help!
So I know that there is no way to align submissions with specific cells, but has anyone found a creative workaround for this that still allows you to identify the submission with proper trigger data?
-
JOIN with 2 columns that are NOT next to each other, and "force" order
I am (trying to) using the JOIN function. It works but NOT the way I want it to. First, the columns I wanted to join were not next to each other. I am attempting to join 2 columns in a specific order and NOT the column in between. What am I doing wrong? They need to be in this order as the essential piece of data is the…
-
IF cell is Blank
Hi I have formula here: IFERROR(INDEX(JOIN(COLLECT({Truck Dispatches (Ongoing Jobs)_Status}; {Truck Dispatches (Ongoing Jobs)_Truck}; [Truck reg. number]@row); UNICHAR(10)); 1) This formula looks at the sheet {Truck Dispatches (Ongoing Jobs)_Status} and returns the Status, by comparing the Truck reg. number from two…
-
what is the best way to bring in something from another sheet but without using parent/child
What is the best way to bring over the revenue budget for a specific employee? there's two rows for each employee since each one is for a specific project. the revenue budget lives on another sheet. I don't want to add hierarchies to this sheet since I'm using it for data shuttle.
-
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…
