-
Form Summary Sheet
I have a form summary sheet that is rating items one to 9. I want to create a Metric that will count the number of "1" or "2" or '3" etc thru 9 for each item. The formula I have been using is =countif({Develop ONE Process Map Template},contains("1",@cell)). That does not seem to be working. I also tried =countif({Develop…
-
Trying to get a date range to appear as a text month
Hi i have a audit planner and i need a actual date field for another formula in the sheet but would like another column to show the auditees when their audit month has been allocated, therefore i would like a formula to convert the date 31/01/2022 from column A to January 2022 in Column B. Any ideas?
-
IF formulas in a Symbols column
Hi, I have a sheet that has a symbols column in it (RAGB) I have created an IF statement in this column based on the value of another column to change the symbol to an 'X' For the FALSE answer, I need to keep the existing symbol. Does anyone know how to do the FALSE bit? (The TRUE bit is straightforward!) Thanks, Will
-
Index/Match Formula - No Match to show Blank
I've been skimming the community here to try and find the IFERROR formula to add to my formula below so that if there is no match, a blank cell populates instead of #NO MATCH. The end goal is to populate a blank row so that users can put the right details into this cell from their reports. NO MATCH doesn't allow this.…
-
How to capture the Name of the person who changes the column value?
Hi all, I'm trying to to capture the name of the person who does the final change in a material release in a process. Please see attached. The goal is to have the name of the person who clicks release (which is the final progress status). Do I need a formula for this? I used created by option in the sheet. Not sure if…
-
Possible method to check duplicate data within multiple columns
Good afternoon, I apologies if there is a simple solution to my question, still rather new😅 Is it possible to create a formula within a checkbox column that would check multiple columns within the sheet against new data within a row, and if all data matches, the box would be checked. For example: An event has been booked…
-
I can't get the PARENT formula to work without a reference
I'd like to use the PARENT formula to retrieve the data from the parent row for a column called Task Name If I use =PARENT([Task Name]) I get #UNPARSEABLE If I use =PARENT([Task Name]3) in row 3 I get the parent data as expected for row 3, and if I drag the formula it auto-updates the reference. However, I then cannot turn…
-
COUNTIFS cross-sheet with 3 criteria
This discussion was created from comments split from: CountIf Formula with Multiple Criteria in the Same Column.
-
VLOOKUP Across Sheets
Hi, Looking for some help from the SS gurus out there, VLOOKUPs across sheets this time. This is the syntax I have at the moment. VLOOKUP({Data Entry - Stage 3 Range 1}[Variant SKU]@row, [Variant SKU]1:Tags2, 1, false) Below are the source columns for the lookup, within our Data Entry - Stage 3 sheet. We would use Data…
-
OR formula---cell range
Hello, I'm having trouble with an OR formula. I want Smartsheet to read a range of child cells to populate the parent cell accordingly. However, the formula I have below isnt working. Thoughts. =IF(OR(Status21:Status61 = "not started"), "Not Started", "In Progress")