Btrombler
Btrombler
Reactions
Discussions
- Hello, I'm trying to build a formula that references two sheets, where if the cell @ row is the same name in one sheet (column Study Name) and the 2nd sheet, then the contacts from sheet 2 populate. H…
- HI all! I'm wondering why "#invalid data type" is showing after i convert this to a column formula, despite there being no date in the "Date-Reserve" column for it to pull from? I would expect it to b…
- I am scratching my head because this is a simple formula I have used in the past, but I cannot figure out why this is returning 0 when there are 2 values that should be summed in this period: =SUMIFS(…
- Hello I am trying to get a sum result based on a date range, but for some reason it is returning 0, any thoughts? =SUMIFS(Amount:Amount, [Date Billed]:[Date Billed], AND(@cell <= DATE (2024, 6, 31), @…
- I'm trying include a date range with counting the number of applicants within various depts, in certain date ranges, but it's saying incorrect argument set. =COUNTIFS(DISTINCT([Name of Requestor]:[Nam…
- Hello, I'm having issues with smarthsheet recognizing my columns names. Any thoughts? When I write the Status:Status piece, it does make them active to that column, but as soon as I get to the Submiss…
- Hi All, Ive been looking through what feels like hundreds of posts trying to find a solution for this. I'm looking for a formula to count the number of times TWO criteria (or more, for future referenc…
