Trending in Formulas and Functions
-
Cross-sheet & condition-based formula
Hi all! I need a formula that imports a reference number (auto-generated) from a column in sheet A (source) into a column in a separate Sheet B (destination), but only when a separate drop-down column in Sheet A changes to a specific value. Using a filtered report in lieu of Sheet B is not an option (at least not…
-
INDEX Collect Based on Text String & Check Box
I keep going back and forth between Unparseable and Incorrect Argument trying the different ways I'm seeing these formulas done in another threads. I can't show the exact sheets. But, essentially, I have a client progress report that we want to show the 'most recent date contacted' and a sheet that we log all client…
-
If And Statement Issue
Smartsheet Community: I am Trying Have My Rag Change to Not Started When The Following Conditions Are Met and Add it to My Existing Formula: IF(AND([Schedule Variance]@row = 0, [Progress Status]@row = "Not Started", "Not Started" I Keep Receiving a Green Instead of Not Started. Her is My Complete Formula Below: =IF([%…