Formulas
Discussion List
- 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…
- 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 mat…
- 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…
- 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 …
- i need a formula to find todays date between the start date and end date, then provide the current sprint
- 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…
- 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 th…
- 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. …
- 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 …
- 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 pricin…