- click links in card "edit" view
I often put URLs in task descriptions on my to-do list, usually referencing an email or something, and I have my card view set to show the description. If the description is short enough that the URL is shown in the card view, I can click it. But if the description is so long that only the first part shows and the URL is…
- easier references to other sheets
Hi all, I prefer to use references of the form {sheet_name Range 1} rather than using the "link from cell in other sheet..." because the formula can be copied to another cell where trying to copy the direct-linked cell only copies the value, not the link. If I have a lot of cells all linked to a particular cell in another…
- "Rollup" column type
In planning budgets, I need to roll up costs into something like this: I can put the formula sum(children()) into the rollup field, but I have to do it manually and I have to do it for all of the parent and grandparent fields. I can't make it a column formula because then I can't enter the values for the children. It would…
- If() and date functions
Hi - I've noticed what appears to be a problem with if() and date functions. One issue is seen here: The "date" column is a "date column" and will only accept dates. The "year" column is a text/number column. The year column uses two different forumlas, which are shown in "column 4." I would expect that the second line…
- Workflow that only triggers manually
I have a workflow that I want to run only on demand. There is a "run workflow now" feature, which is great. But the workflow is required to have a trigger as if it would run automatically and I end up making a trigger condition that I know will never happen. It would be cleaner to have a trigger of "manual only" or "never"…
- Highlight conflicting predecessor relationships
It is possible to create predecessor relationships that are not possible. Consider: Task C is supposed to finish at the same time as Task A, but it can't because of other constraints. Currently, SmartSheet silently ignores a condition like this. This happens to me when trying to build a project around external constraints…
- Predecessors in clonflict
Hi all, Consider this situation: report is due 8/1/22 work is complete on 6/1/22 report is written - predecessors are #2 and #3FF If the report takes 2 days to write, those two days will end on 8/1, since there's a FF predecessor relationship - great. If the report takes 90 days to write, the predecessors are in conflict -…
- 如何“继任者()”给直接successors?
Hi - I find a "successors" column useful. I can easily make a column with a column-formula of JOIN(SUCCESSORS(X@row),", ") - great. But if the successor is a parent row, I get not only the successor row shown but also all of the children of that row. Like this: I don't want to know that the tasks on lines 3 and 4 are…
- Allow Successors() to show only immediate successors
I like having a "successors" column to complement the "predecessors" column - I use this to trace forward to find tasks that are affected if I make a change. However, the successors() function returns not only immediate successors, but every task that is a child of those successors. While this may be technically a true…
- copy/paste loses links to other sheets?
Hi all - I'm trying to replicate a piece of a plan within the same sheet. I'd like the duration of the tasks to be the same in both versions so if I change the duration in one version, the duration changes in the other version too - but it seems you can't link duration cells to each other. What you can do, though, is link…
