-
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,…
-
Check Box & IF Statements
Appreciate some pointers on this if possible.. I have 5 Columns in my Smartsheet.. the first 4 are Check Boxes, the 5th is a Text/Number.. Columns as follows.. [North] [East] [South] [West] [Direction] In [Direction], I want to display text dependant on the Checked Boxes status.. it can be any of the first 4 boxes or any…
-
Assigning a date to a value
I'm working on a gantt chart that is tracking teams progress on a project using agile development. Business Case / Background: When the teams provide updates to when a task is going to be completed, they reference the name of the sprint we're in. So for example if "Task ABC" will be completed in Sprint 1A that means its…
-
Numerous issues in last few days
Have others been experiencing any unusual activity in the past few days? I have been having a number of issues that appear to be related to permissions and reports e.g. A report we use daily suddenly showed a permission error for one of the users in the team although their permissions have not changed and they are owner of…
-
Filter based update requests
Hello dear Smartsheet staff, I noticed discussions about update requests, some concern single or multiple rows, others concern columns or the whole sheet. Could it be possible to implement FILTER-BASED update requests? I guess that would satisfy everybody's needs. Best,
-
Return entire row when value is matched in another sheet
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 sheet which match a specific…
-
Completed Row Drops To Bottom
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?
-
Revert to Single-User Contact Column from Multi-User Contact
Hello, Experimenting with the new Multi-User Contact Column, I've found out the hard way that it is treated as a separated Column Type. In other words, when running a report I need to have check 2 "Assigned To" columns. I went back to the Sheet that had the "Allow multiple contacts per cell" checkbox checked... and looks…
-
Adding new workspaces to an existing report
Hi Smartsheet community! I have a workspace that we frequently "save as" for new projects. The format, columns, etc - stay the same for every workspace, every project. Is there a way for my new workspaces to be automatically added to my roll-up report automatically? Please?
-
Exporting Excel formulas
I noticed that formulas, even simple formulas are not exported to a Excel. I have a big smartsheet where we created butcket that has additions per row (summarized) and we noticed that they're not exported as formulas in Excel. It's a shame because we have to start over in Excel an create template and data again. Is there…