-
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 *…
-
Move Control Center profile data to Sheet Summary fields
Having to list the profile data in the template is messy and distracting, and frankly looks pretty janky. You already have Sheet Summary fields tucked away on the side panel, able to run formulas, collect metrics, and link in data from intake. This would obviously require the ability to cell link out from Sheet Summary to…
-
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…
-
Unable to transfer ownership of specific Smartsheet items
I used to be able to click share for a specific sheet and make someone a owner of a specific document. A few weeks back, the "Make Owner" option stopped showing up. Is there a reason this option was removed and what is the workaround?
-
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…