-
Formula Help Calculate # of Days with 2 date fields, unless date field is blank use todays date.
I need a formula for column "Days to Build" I want the number of days it has taken to build using Build End Date - Build Start Date = Days to Build, but if there is no Build end date I want it to be today - build start date = days to build.
-
Using ISBLANK when a field is not blank to autofill in a checkbox
I am creating a complicated workaround since when requesting an update (apart from using a form) Smartsheet can't require request for update fields to be filled in. So, I need to run an automated workflow update request on fields left blank (that arrive after the enterer sends the update, not at the same time). In order to…
-
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?