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

I have a source sheet with hundreds of rows of entries. One of the columns is named Property. There are many different values under this column. I have a destination sheet for each one of these possible values (in this case, a property). 

What I would like is to have have any rows in the source

I understand I can likely do this with a very, very long VLOOKUP  or IF/THEN formula in every cell, but I'm dealing with over a hundred items and that will be unwieldy. 

Situation:

I would like to have a form where someone selects one option from a dropdown of ~100 items. That value then populates

Hi everyone,

While at Engage18, I heard there would be a way to have a row drop to the bottom of the sheet, once completed. Does anyone know if it's at all possible right now, or is this something they are still working on?

We are wondering if anyone knows how to build a public facing sheet that has a search box where customers could type in a word or two and then have it return any hits. The data that would be searched could be linked to another sheet and that file would not need to be viewable on the public one. Is

Hi Community,

we are using Status View at the moment to share the actual status of IT requests (Demands) to the requestors of different department. The access is given to the requestor via their email address they have to maintain while handing in the request and then they have to login in to status

I've got formulas in my sheet that calculate due dates that fall on weekends, and I've used conditional formatting to highlight those dates to alert me to those dates that are on Saturdays and Sundays.  Now, I want to move those dates to the Monday next.  Is there a way to automate that?

Hi there,

I have a task owner column (formatted as Contact). It seem very random on which users it will look up so I'm having to 'Allow' non-users a lot.

I thought it might be change, where SmartSheet isn't allowing allocation to a non-licensed user however it sometimes won't pick up licensed

I am trying to update the below status formula to update the "yellow" status to be determined by a % complete less than 25% and the Due Date (week of) is between 7 and 14 days in the future.  

Here is the current formula:

=IF([% Complete]26 = 1, "Green", IF(AND([% Complete]26 <= 0.25, [Due Date

Hi all

My team and I use the smartsheet app on mobile devices and find it amazing and quick for what we need....until the recent app update.

The predictive text section has disappeared and has been replaced with an option to scan barcodes, again a highly valuable tool for what we need, but the