Sign in to join the conversation:
I need help with determining the right formula - Scenario:
If the value in colum 1 row 2 is "word" , than multiply (column 2 row 2, column 3 row 2, etc)
Thank you in advance for your help!
=if([column 1]2 = "word", [column 2]2 * [column3]2
The Issue My project-specific metadata sheets use INDEX/MATCH formulas that reference the Intake sheet using a Project ID. When the automation archives rows from the Intake sheet, these formulas break because they can no longer locate the source data. Example formula: =INDEX({Project Intake Name}, MATCH([Project ID 1]@row,…
Two of my five automation workflows appear to have just randomly stopped performing on April 9, 2026. All others, which would/are performing as normal and would be functioning alongside the other workflows, are functional and appear to be untouched by this 'bug'. Help I've tried all that I can think of.
I need to add 2 horizontal lines to my stack chart to show when we have over allocated for our resources and where our average is. Does anyone know how to make this happen in a Smartsheet dashboard?
