-
IF formula to combine rows if checkbox checked
Is there a way to do this? I would like my Primary Column (Task Name) to combine it's text with my 'assigned to' column if the condition of the checkbox in column 'Show' is checked. thanks Mike
-
Two sheet references in one sheet?
Hi Everyone! I am attempting to reference two different cell ranges from another sheet into one status sheet. However, when I create/update one sheet/cell range the other sheet/cell references change to the new one. Can you have more than one cell range reference from another sheet into a landing sheet?
-
Nesting MIN and IF functions
Hi, guys! I am trying to create a function which will tell me the next date where a certain condition is met. I have a column called "Due" with due dates for a report and a column called "Received" with a checkbox. I would like to calculate the due date of the next report which has not already been submitted. To find the…
-
Formula Date Remaining Static
I have aprroximately 30 sheets related to a corporate merger. In every sheet I have a formula that populates today's date +1 whenever a status column value = Complete. The formula is: =IF(Status2 = "Complete", TODAY(1)) This then triggers a reminder to a supervisor to review the task and approve its completion. So, the…
-
Sum Reference in another sheet
Good day All: I am trying to use a SUMIF formula that would allow me to add everything less than 2,000 with multiple status. Here is the formula I am using but I am receiving an invalid operation. what am I missing? =SUMIFS({A3: Fi TLS Merchant Impact List Range 3}, <2000, {A3: Fi TLS Merchant Impact List Range 2}, "Left…
-
Programatically select a subset of a column
I want to be able to average, or other function, over a subset of the cells in a row. The number of cells I want to include is specifiied in a separate cell. In Excel, I accomplished this with OFFSET. I read another article here noting that smartsheet doesn't have OFFSET, but that MATCH and INDEX might be able to be used…
-
Index and Match - Referencing a different sheet
Is it possible to do an Index and Match referencing another sheet? My formula works when I am using data on the same sheet but when I try to reference a different sheet it does not work.
-
Counting results of formula
Hi, I have a sheet with two date columns. I want to count the rows where only one of the date columns have a value. I´ve tried to create a third column with a formula that sets it to 0 or 1 depending on whether the second date column ISBLANK. It works but a cant count the zero's or one's since it seems smartsheet cant…
-
COUNTIFS criteria is CELL+anything
Hi, I've created a rather complicated cross-sheet formula that counts cells from a different sheet using 3 criterias. One is the description that starts with a text mentioned in a cell above. I've tried to enter the search criteria into the formula like this =COUNTIFS({Other sheet Range 1},$Column$14 & * , ...)…
-
Creating Sub-Auto Numbers
Hello, We are currently using a web form for customers to submit a service request. After the form has been submitted a auto-numbering confirmation is generated and the customer is sent a notification with that confirmation number. When we process the request we often need to split the service request into multiple…