-
Formula IF OR CONTAINS - Change State to State Abbreviation
I have a State Column and a State Abbreviation Column. The State column is a dropdown column that is filled out from a Form. I have a Formula in the State Abbreviation Column that looks at the State Column and then populates the appropriate State Abbreviation. Here is my issue for West Virgina and Arkansas it populates…
-
Change Status Based on Previous Row
I am trying to create a column formula that will change the status of a row to "Ready for Work" when status in the row above it changes to "Complete" I tried to follow the information that was provided this thread, but I keep getting #UNPARSEABLE: I already have an auto-number column (Job # - font is just in white based on…
-
What formula will return one of three date fields based on set critera?
Okay, so here's another one for the community We have a tracker with three date fields. The PM Received date #1 should take priority and be returned if not blank, otherwise, we want one of the other two dates, whichever is not blank. (and only one of #2 & #3 will be not blank) PM Received Intake Date: The actual date…
-
Assignee reporting for all tasks during specific date ranges
I have been trying to create a report that shows all the tasks my team have on each week. I found some guidance in a community post about setting filters based on the start and end date. However I have found this doesn’t provide quite what I need so I was wondering if someone might be able to help me. Basically, I want to…
-
Looking to create a formula to count number of tasks
On the "Corporate Legal" row the formula in the "0 of 8" is the following: =COUNTIF(CHILDREN(), 1) + " of " + COUNT(CHILDREN()) I want to create a Parent Count for all tasks. There are other sections with the same setup. I want the parent section (the cell with a blue border) to count all number of tasks. So if I have "0…
-
Split Multiple Selections In Single Form Into Individual Rows (Core Product)
There have been a number of people asking how to make multiple selections in a single form and then have those selections broken down into individual rows, and the previous answer was always to use a 3rd party app, a premium add-on, or the API. Below is a set of detailed instructions on how to accomplish this within the…
-
Cross Sheet Reference Maximums
Hello! Does anyone know if cross sheet reference maximums increased since Engage? I know sheet capacity increased and cell link capacity increased, but I don't recall cross sheet references specifically being called out. As far as I am aware (and is still documented: Smartsheet Help Page), there is a maximum of 100 cross…
-
Index/Match with Has and Specific Select
I have an master roster and each week I need to ensure a response for each. Since each responder has mutliple areas of responsibility, one submission may cover multiple items from the master roster. I used an index/match formula however when there are multiple entries in a single line, I get a #No Match. And now that the…
-
Index collect formula question
Hello I need some assistance with my index collect function, In one cell i'd have =IFERROR(INDEX(COLLECT([Location and Event]:[Location and Event], [Column23]:[Column23], [Week #]@row, Email:Email, "Person 1"), 1), "") In another cell i'd have =IFERROR(INDEX(COLLECT([Location and Event]:[Location and Event],…
-
Subtraction Formula?
I have a value of 02 and I would like to have a formula that would return 01. Is the a way to do this? 02-?? = 01
