-
Linking / Updating Sheets
Afternoon All - I have a slightly complex question I wanted to pose to the community to see if I could get some thoughts. I have two sheets that I want to have "talk" to each other. One Sheet (Master Sheet), is where our team spends their day looking for requests to come through. In a second sheet (Change Requests Sheet),…
-
Formula to calculate total sum from a hierarchy column criteria
I have the following sheet that I want to calculate the sum of "Number of slides" which appears in the hierarchy translation column. I've done this same thing with only counting the instances instead of summing them, but I can't get the formula to work for the sumif in the same way that the countif formula worked before. I…
-
Extract Series of Occurrences of Strings into Separate Columns
Hi @Paul Newcome , You mentioned in another thread here: https://community.smartsheet.com/discussion/63606/extracting-string-from-a-cell? "If you wanted to parse them out across individual columns, we would instead use a series of LEFT/FIND and MID/FIND statements." The previous thread looked to me like someone was using…
-
How to use index/match on multiselect dropdown list?
I am working on launching a global hiring form that uses this formula: =IFERROR(IF(Country@row = INDEX({Approved Seats Country}, MATCH([Unique Seat Code]@row, {Approved Seats Unique Seat Code}, 0)), 0, 1), 2) Basically this formula returns the number "1" by searching for the name of the country in the source sheet…
-
Count rows based on another column
I have a sheet like this: Case number | Date entered | Cases/day I want to count the number of cases per date entered. I'm assuming I would use the COUNTIF formula but I'm not sure how to tell it to count the cases for each date as opposed to if the date = some value. Thanks!
-
Generate a Report by using sheet summary
I'd like to generate a report that shows : Which tasks are in progress ( Including their parent ) which tasks are at risk ( Defined by tasks that were supposed to be started but are not started yet ) and it should show their parent as well. One of the problems I have is that under a given milestone, there can be several…
-
Auto-Number generated for parent/children rows
I am trying to build up a WBS and would like set a number generator to auto ID the various levels (control accounts and work packages). I would like to have the parent row, or control account, have an ID of 1.1 and the work packages, or child rows indented from there, to have an ID of 1.1.1, 1.1.2, 1.1.3, etc. Being a…
-
Auto number when box is checked
question on how to generate a number when a checkbox is checked. This seems simpler than other peoples asks, but I can't seem to make it work for me. screenshot is the area that needs to be addressed. I want the [PO #] (currently set to auto-number every row)to generate the next number ONLY when the [PO needed?] is…
-
Trying to return a value once, but not when cell value changes
Sorry I don't really know how to phrase this. Basically in the projects we have, we get a quote from a vendor, and they automatically enter it into our project sheets. Because this can change to a lower price or cancelled altogether we set up automation so our price column changes to the lower cost, or to zero if…
-
MIN (Collect) with multiple cross reference criteria?
Due to the 500k cell limitation, I have to break my source data up into multiple files. I am attempting to write a formula that looks for the MIN date across date columns in two files when the row includes the customer name. This is what I have and it isn't working. Would love some help. =MIN(COLLECT({sheet1-date},…