-
Can we auto create the Row Link as a Hyperlink to autoconnect to that row yet?
Please tell me this is available. It would be nice to be able to create a column on a sheet that will automatically create a hyperlink to that particular row!!!
-
How to create a dual dynamic list of unique column values - including a short list of associated values per unique value?
I'm looking to create a 'dual list' of unique column value pairs. I can create a single list of unique column values with a helper Row # column and the following formula: INDEX(DISTINCT(COLLECT({Epic ART Impacts: ART}, {Epic ART Impacts: Epic ID}, [Epic ID]#)), [Row #]@row)) When pointed at a list with MANY duplicates,…
-
Elapsed time accounting for weekends
I see many threads referring to elapsed time calculations (i.e. the time between a start date/time and end date/time) and many promises from Smartsheet to add this function natively at some point, yet I still don't see a solution. This is a complete showstopper for our application of Smartsheet. We need a way to calculate…
-
COUNTIFS Cross Sheet Error
I have written these hundreds of times but for some reason I am missing something with this one. Simple, trying to count "Health" based on what we call Seq, in this case TSK. Building a metrics sheet for Dashboards. This formula is producing a Unparsable error and I cannot find the error. =COUNTIFS({DSV 3PL Schedule Range…
-
RAG Roll-up formula
Could anyone help me with a formula I'm trying to perfect. I am trying to create a formula that automatically captures RAG status for Children Rows and how this is communicated to the Parent rows. The plan is essentially structured like this (images are attached): * Project Plan Summary (Senior parent)* Main Tasks…
-
Restaurar filas perdidas con datos adjuntos
Por error se ejecutó una automatización y se borraron todas las filas de una hoja con muchos archivos adjuntos, necesito recuperar todo y mantener el orden para poder continuar mi trabajo, ¿es esto posible?
-
What is the best way to bring in data from another sheet without a direct matching column on both sheets?
My goal is the bring in contact information (Name and email address, 2 separate columns) from a reference sheet {Sheet A} to my target sheet {Sheet B}. I've used {Sheet B} as a reference on many other sheets for the same purpose, however, the data on this particular target sheet is inconsistent with the reference sheet.…
-
How to create a unique number via formula or how to autonumber via formula due to existing autonumber type column?
All, The way my Smartsheet workspace works: Every time the Status column of a particular request in Master sheet is changed, the entire row is automated to be copied to Status Tracking sheet. The change is timestamped as Change Timestamp and the Subsequent Timestamp is recorded in Status Tracking sheet with every…
-
How to maintain permanent inventory levels when source data is deleted weekly
Hi all, I am looking for advice on the best workflow to manage inventory deductions. I currently have two sheets where Sheet 1 (Master Stock List): Contains hundreds of items, locations, and catalog numbers. Sheet 2 (Weekly Usage): Operators log items used during the week by scanning QR codes. Currently, Sheet 1 uses a…
-
How to maintain permanent inventory levels when source data is deleted weekly?
Hi all, I’m looking for advice on the best workflow to manage inventory deductions. I currently have two sheets: Sheet 1 (Master Stock List): Contains hundreds of items, locations, and catalog numbers. Sheet 2 (Weekly Usage): Operators log items used during the week by scanning QR codes. Currently, Sheet 1 uses a SUMIF…