-
Bridge designer Run Log and Element menu viability
In the Bridge Designer view change is so that the Elements setting menu and the Run Log can both be visible at the same time. From what I understand one of the core functions of Bridge is to copy reference data from the Run Log into the setting screen of a later Element. I find myself forever repeating this process of…
-
Open in New Tab
Is there a way to configure your personal settings to always open new items in a new tab?
-
Multiple equations under SUMIF or SUMIFS
Can I create an equation that will sum and multiply multiple times in one equation - basically combining these individual equations that work alone? Tried a SUMIF and SUMIFS versions but keep getting Invalid operation when I try to combine: =SUM(JUL@row:[JUN25]@row) * [INFLATION 2024 5%]@row =SUM([JUL25]@row:[JUN26]@row *…
-
avg a column of days if they equal a value in another column
I am trying to average time to sending an email to make an appointment after an inquiry for each team member. This is the formula I tried: =AVERAGEIF({Case Consultation Tracker Range 4}, {Case Consultation Tracker Lead}, @cell = "SB") The column to average is Range 4 which is a formula measuring the difference from Request…
-
CountIF Formula with Criteria
I have a formula to count how many stores an owner has in our system. It is working great: =COUNTIF([Primary Contact (Company) (Company)]:[Primary Contact (Company) (Company)], [Primary Contact (Company) (Company)]@row) (You can see John Voskamp has 91 stores). I need to determine of the store count, how many are "Open".…
-
Removing Zero from my results
Can anyone see what is wrong with this equation. Trying to remove zero from my column when nothing has been done. =IF({08 - Estimating # of Pricing} = 0, INDEX({08 - Estimating # of Pricing}, MATCH([Job #]@row, {08 - Estimating Sheet Job #}, 0)), "")
-
How to index /match that has multiple dates- but I want the latest one
I have read so many index/match, max/collect, and index /collect questions, and all of them seem to be just a little different than what I need, and I can't figure this out. So I have two sheets, one data sheet that I am pulling from based on criteria from another sheet. Except the data sheet has multiple entries and I…
-
Form Question
Hi there! I am trying to use a form to capture data from several facilities that needs to roll up into one dashboard. The initial audit applies to a unit that should roll up to a hospital and then to an overall enterprise. I'm having trouble figuring out how to use a form to complete that. Any insight would be greatly…
-
Copy/paste data from row above
Still new(ish) to Smartsheet - can someone provide a formula or series of steps on how to prefill data in cells that are blank to what is above (no these are not parent rows). This link shows how I would do it in Excel. but I'm unaware of a "go to special" button here to replicate the process. Thanks so much! - Ilana
-
COUNTIF/IF Formula Help
Hello, I'm trying to combine a COUNT IF and IF statement to another sheet. Here is my formula: =COUNTIF(IF(AND([14 Apr 2024]1 >= {Project Intake Start Week}, [14 Apr 2024]1 <= {Project Intake End Week}), 1), >1) Essentially, I have an IF statement that says if a number (referenced on the sheet) is between two numbers on a…