-
If Formula Help: =IF X symbol and X symbol are X, display X in this column
I'd like to select text in a column based on symbol indicators in a column. For example if they are highly impacted, with a "!" symbol and they are not influential with a (down arrow) symbol, i want to indicate that i should reach out to them weekly. See pic. Please help with how I can set up the formula to do this…
-
Can "@row" be used in the Intake Sheet Summary page calculation?
Hi, Just need a sanity check please. Can @row be used in the Intake Summary page calculation? I assume it won't work because it is a summary. However, [field]x:[field]xx (where x is the first row to consider and xx is the last) works.
-
Is there a work around to capture modified by for a cell instead of the row?
Hi everyone, I’m working with Smartsheet’s Dynamic View and I’m wondering if there’s a way to automatically enter the email of the person updating a specific cell into another cell. I only need the email to be captured when a particular cell is updated, not the entire row. Modified by will not work because that changes any…
-
Index Match returns "#No Match" for Project Manager but works for Project Sponsor
In Metadata, the Formula is basically the same between the two fields but Project Manager is returning #No Match and Project Sponsor works. The references are going to the correct places. Can someone please help me find the discrepancy? Thanks!
-
No Match error with Index Match
Hi, I have a column in sheet A that uses the Index Match function to collect data from different sheets. The formula worked perfectly with two source sheets, but I keep getting the #No Match error when referencing one specific sheet, despite double-checking the search value to ensure it matches exactly what I have in Sheet…
-
IF {Status} is "X" or "XX" and {Date} is in the coming 90 days
Hello, In the formula below I am asking if the status in a reference sheet is "Pending Submission" or "Pending Approval" then display "No" in a symbol column. I would be very grateful for any best practice on how to structure the formula to add in if {status} is "Pending Submission" or "Pending Approval" and a {Date…
-
Formular to add up qtys from another sheet
Hi Guys I have a main smartsheet with all my products and current stock levels on, and another smartsheet which has all the product movements and quantitys, this sheet will be the one users update What I need is for the stock levels for each product on the main smartsheet to update based on the movements file. In both…
-
Smartsheet Updates
I am curious what other users would think about this. I was working on a project recently and worked out the formulas in Excel since that is where I have more experience. Got everything worked out and it was awesome, and all the formulas worked well within Smartsheet, besides one. The one formula that did not work was an…
-
Line Charts in Dashboard not displaying data - requires save to display?
I've built numerous dashboards and have never encountered this error previously. i have a formula: =AVG(COLLECT({Material Requests (Draft) Range 10}, {Material Requests Range 1}, "1", {Material Requests Range 2}, "2024", {Material Requests (Draft) Range 3}, "Central")) This results a figure (0.39) and when I go to chart…
-
Circular Reference
I am working on a RAID log and want the "Next Action Owner" column to be filled in with the name in the "Created by" column if people do not add a name in the "Next Action Owner" column. Is there a way to edit the formula that I currently have in the "Next Action Owner" column to have this done without receiving a circular…
