-
COUNTIF Formula for when a cell contains a specific word/phrase?
I'm trying to create a formula that allows me to count the number of times the word "Postcard", for example, appears in a list in a column. I am referencing a column in another sheet to do so. However, nothing I've tried works. My instinct was to try =COUNTIF({2018 Open Enrollment Feedback Range 1}, "Postcard"). However,…
-
Software vendor comparison sheet template
Does anyone have a software vendor comparison sheet to share with the Community? Comparing features and functionality of various vendors in one sheet is a challenge. What do you think would be the best sheet template to compare vendors?
-
Upgrade not kicking in
Anyone know why an upgrade wouldn't kick in immediately? I've received a confirmation email from Smartsheet, and my card shows the charge -- yet my account is still frozen (two hours and a relaunch from a cleared browser later). Frankly, I'm also a little disturbed by the lack of response to my email so far (and the…
-
Average of lease $ amounts in a certain region
I would like to see the average lease amount per region. I am cross sheet referencing. The formula for the average works. But when I add in the second part (countifs) to make sure a PE GL Checkbox has been checked and to specify a region (I do a cell reference) it doesn't seem to work. For instance, in 1 region I do not…
-
Formula from hell
I have ranges of data in multiple forms. There is criteria that must match from each to be summed on a third sheet. The criteria are GL Accounts and a month Code. One of the month codes is listed as 12 Month. The intent of that code is to signify that the cost in one of the columns should be spread across 12 months. So I…
-
SUMIFS
I am trying to sum accounts receivable for individual salesmen. I have gotten to the point where I can add if the check box under [Check Received] is marked but I do not know how to sum if a check box is unmarked. So far my formula is returning 0 when it should be returning a over $100,000. This is my formula so…
-
Smartsheet connection with Alteryx workflow
Hi, Someone facing an issue to connect data from Smartsheet into workflow in Alteryx? I have an Alteryx with data connected from Smartsheet that always worked well, but last friday the alteryx wont able to connect with Smartsheet, the message in Alteryx is "No valid Fileds were selected. This connection between Alteryx and…
-
Limiting Access to Hyperlink
Is there a way to prevent the other sheet user to open the a link/URL hyperlink to any row, whenever someone else is using the same link?
-
Automatic Form Repsonse
Hello, I have a form in which staff submit their mileage journeys. In the smartsheet (not the form) I then have a column which totals all their journey miles to give the total mileage completed and the amount to be paid to them which the person submitting doesn't get to see. Is it possible to set the sheet up so that an…