Formulas
Discussion List
- 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…
- I need to calculate the 1st of the month following 60 days of employment. Ex. If a hire date is 1/15/2024, then I would need the formula to return 4/1/2024 (60 days after 1/15/24 is 3/15/24, so April …
- I have a request to create a way to track a certain record's time since it's been opened, but the user would like the tracked time to not include when it's in a certain status. For example, if the rec…
- I have been using a COUNTIF formula that I am unable to convert to a column formula. Is there a way that I can alter it so it can be a column formula. This is what I have: And this is the message that…
- I have been using a COUNTIF formula that I am unable to convert to a column formula. Is there a way that I can alter it so it can be a column formula? This is what I have: And this is the message that…
- I'm building a spreadsheet with monthly metrics and having issues creating a formula. There will be a separate smartsheet with individual events (1 row per event). The formula I'm trying to build: For…