-
Incomplete work left to go
Is there a way to calculate work days "left to go" where the task is not marked complete while ignoring simultaneous tasks (tasks that have the same predecessor)? It seems like networkdays should get part of the way there but it seems like i need an "if" statement to look at complete. Is there another way to get there that…
-
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?