-
Referencing Another Sheet
I am entering data (BC23-111) in red block, and trying to reference another sheet to pull back the file name when there is a match of BC23-111. I keep getting a #UNPARSEABLE error message. I feel like I am close but cannot seem to get past this error. Any/all assistance is appreciated, thanks.
-
Formula for parent, child, grandchild auto add rows
I am building a spreadsheet for our new hire onboarding and IT checklists. When I add a new name I would like it to auto populate children underneath it. See my screenshots below. Row 7 (Parent) - Dark blue would be the start date for new employees Row 8 (Child) - Light blue would be the individual employees (we normally…
-
Checkbox on one sheet to autofill checkbox on another sheet
I found a very similar question asked about a year ago around this (https://community.smartsheet.com/discussion/98302/can-a-checkbox-in-one-sheet-be-auto-checked-based-on-a-checked-checkbox-in-another-sheet) but I cannot wrap my head around the formula provided as a response. I have a sheet where I am checking off a box…
-
How do I automate the creation of a project schedule from a form submission?
Hoping someone might be able to help me figure out this workflow: Form is submitted requesting a new project with the following information: name of project, requested go live date, assigned project manager This form submission triggers a workflow that will automatically pull a project template, inserts "name of project"…
-
Create a list from column data within existing(current sheet)
Hi All, Quick query, I have a sheet of data with my Issue Key column holding data that I want to reference. I have a secondary column that i want to have a list generated based off that data. this is all within the current sheet. so; Issue Key | linked item a | (this is a look up that contains a - e) b | (this is a look up…
-
Countif containing specific text
Hello! I am trying to count to see how often a specific word, in this case a person's name, appears in a range of text. I've looked over similar questions and have started a formula, but I end up with an #INVALID OPERATION error. My formula is =COUNTIF({January Range}, FIND("Cassie", @cell, > 0)) I've also tried…
-
Tracking percentage on a chart overtime
Hello! I am trying to figure out how to create a line chart that shows the updated % every time it is recorded. I know how to change the percentage complete by using formulas, but this percent is an actual percentage of a recorded number. Not a progression percentage. Is there a way for me to do this so I don't have to…
-
Why cant I count in this date range?
Im tying to count the amount of RLO's between the dates below and am not sure why its an #incorrectargument ? =COUNTIF([RLO Receive Date]:[RLO Receive Date], >= DATE(2024,01,01) <= DATE( 2024,4,1))) Anyone help me with the syntax here?
-
Conditional Formatting a single cell when rows and columns switched?
I've setup a sheet to easily visualize different metrics for each month for different departments. Each metric has a different score that needs to be met, otherwise if it falls short of the target, then I'd like for it to change to red. The problem is, that different metrics have different scoring requirements, therefore,…
-
Why cant I count in this date range?
Im tying to count the amount of RLO's between the dates below and am not sure why its an #incorrectargument ? =COUNTIF([RLO Receive Date]:[RLO Receive Date], >= DATE(2024,01,01) <= DATE( 2024,4,1))) Anyone help me with the syntax here?