-
COUNT Formula for counting number of comments in another sheet
Hi! I am trying to figure out how to write a COUNT formula to count the number of comments in another sheet by using a cross-sheet reference. How do you include a comment count in a Smartsheet formula?
-
VLOOKUP/INDEX/IF Help?
Hello, I'm attempting to integrate data between a "Master" sheet and a "Daily Entry" form. I'm trying to populate the "Quantity Completed" with the value in the "Parts Run" cell after successfully matching the Part Numbers in both sheets, circled in red. In a perfect world, an employee would enter their daily work report…
-
Nested Index Collect to gather data from multiple sheets
Hi all, I am trying to create a sheet that pulls data from multiple others. I want to populate the person from Sheet 1 when the collection sheet column for client matches the Sheet 1 column for client. The basic formula from one sheet works: =IFERROR(INDEX(COLLECT({Sheet1 Person}, {Sheet1 Client}, Client@row), 1,),…
-
VLOOKUP and COUNTIFS
Hi all, Hoping to get some help with a LOOKUP/COUNTIF formula. I'm trying to create a grid that counts issue location by month. I've created this column in the source sheet which is the range for the VLOOKUP. The sheet that this information needs to be pulled to: I'm struggling to create a formula that will count each…
-
Whats the formula to find todays date between a range of dates to provide a value?
i need a formula to find todays date between the start date and end date, then provide the current sprint
-
Using WebHooks & API to create your own custom Column Functions
I thought it might be useful to share a general method I developed to add Functions missing from Smartsheet. This technique makes use of WebHooks & the API. Most important: users can add this to their sheets nearly as easily as they can add formulas. They do NOT need my help as a programmer For example here are a couple…
-
Index - Distinct returning an error
I am using this formula to pull distinct entries from another sheet: =IFERROR(INDEX(DISTINCT({Linked Sheet Range 11}), $IDX@row), "") The entries are returning as blank - so indicating an error for the whole column. I have used the same formula in the sheet for other data ranges in the same source sheet and it's working…
-
ISCRITICAL is FALSE for a PARENT task with CHILD tasks that are on the critical path
I have a project plan where the child tasks are on the critical path with ISCRITICAL = TRUE, but for the parent task, ISCRITICAL = FALSE. Is this expected behavior? Context: It's a waterfall project. Only the child tasks have predecessors and successors so that the dates and duration for the parent task adjust when the…
-
Fórmulas a la hora de crear automatizaciones y flujos de datos
Buenas tardes, Tengo un par de consultas acerca de las fórmulas a la hora de crear automatizaciones y flujos de datos.Por un lado, cuando se crea una automatización no he visto forma de que añada una fórmula en una celda, ya que si la creo como "Cambiar valor de celda" no lo aplica como fórmula, le añade un apóstrofe al…
-
If or Collect statement to bring back correct pricing
A vendor has given us a step price increase over the next 3 years. But I can't figure out the best formula to bring back the correct pricing. I have 13 sheets that will reference this sheet for pricing. In order for the pricing to generate for our use, I need it to be correct for the year. It's going to be complicated.…