-
VLookUp - #INCORRECT ARGUMENT SET
Hello team! I'm trying to reference all of the columns from one smart sheet (let's call is smartsheet A) to another (smartsheet B). Here is my formula: =VLOOKUP([Helper Column]@row, {Smartsheet A}, 7, true) 7 is the location of the helper column in both smartsheet A and smartsheet B. All of the columns in both smartsheets…
-
Index match returns a wrong value
Anyone able to help with an Index/match formula that returns a wrong value? We've a formula that is returning a wrong value. I believe the formula is correct (it's the same way I write it in .xls). We are referencing another Smartsheet in the formula. I understand if I was getting an error (#invalid value, #No match), but…
-
What's the best way to have several photo upload sections in smartsheet?
I've been asked by our superintendent if Smartsheet is capable of having a form with the below information: Supplier Invoice Picking List Number Container Open Door Photo Container Number Photo Seal Number Photo What is the best way to capture this information in a sheet/form? Thanks in advance :-)
-
Error #BLOCKED
Buen día, se me está presentando el siguiente error en una de mis hojas. Actualmente en la hoja hay 2890 filas con alrededor de 90 columnas (la gran mayoría formuladas). Al intentar mudar filas a otra hoja para depurar la memoria sigue permaneciendo el error y las celdas aparecen "#BLOCKED". También, ya intenté quitar…
-
Smartsheet Report in Card View Populating Data Incorrectly
My team is having an issue where a report suddenly stopped showing appropriate data based on the filters on the report. We are using the report in the Card View with the Assigned To contact as the grouping method, but people that are being filtered out are showing with 0 items and people that should be included are…
-
Daily Reporting to Document Generation
Good Afternoon, Our construction firm utilizes a standard Gantt chart sheet to track our project's daily reports. Under each category of work we have milestones, i.e. Carpentry :: Framing :: Drywall etc. Under each milestone we add a child for that days work, i.e. Drywall :: Day 1 - Mobilized :: Day 2 - Started Hanging…
-
Print completed forms without Business Plan
Hello! I am the sole Smartsheet user in my company (I'm trying to bring them along, but so far I haven't gotten with the right decision-maker). The main reason I use this at this time is for training and in-service acknowledgments. I used Smartsheet at the enterprise level with a previous company and convinced my current…
-
Conditional copying of rows from one sheet to another
I am building an inspection sheet and form where our operations team will be able to mark pass/fail through a checklist. If something "fails", I want that specific row in the inspection sheet to be copied over to another project tracking sheet. These two sheets will necessitate different fields. Upon the specified…
-
Formula Question
This is my current formula that is producing error - Unparseable, I can't seem to figure out what the issue is. =OR(IF(INDEX({Min_Skill_LTT}, MATCH([Job TItle]@row, {Minimum Skill Requirement Range 1}, 0)) = ([LTT Matrix Use]@row - 1,{Min_Skill_LTT}),"True", "False"),(IF(INDEX(MATCH([Job TItle]@row, {Minimum Skill…
-
Smartsheet Gov JAWS (Screen Reader) Computability and Accessibility
In the current build of Smartsheet Gov, the highlighted cell in a sheet does not have the cell text / input connected to the name of the cell to be read by a screen reader. Three different screen reading software's were not successful in trying to read aloud the text in the highlighted / in focus cell. Having this issue…
