I have a sheet where I have all my projects and then sub categories indented underneath it. Is there a way I can easily add a new project that will create automatically add the sub categories?
No, at least not inherently within Smartsheets. To circumvent this we keep a template at the top of our sheets that we can copy to create new "projects." You would just have a blank project with no dates and all the durations and dependencies set up. Then you can just highlight and copy the rows to create a new project.
I add a column with the sub tasks listed as a multi select drop down. Then use that to track the status of the sub tasks. It's an easy way to track deliverables for each row but does not enable all the features of a true sub task…
Is it possible that a workflow that MOVES rows to another sheet too basically do a CUT/PASTE (like in Excel), and then you are left with BLANK rows on your original sheet? I cannot think of any other LOGICAL reason why this would happen. The users enter the data from an Intake Form, it gets placed onto this sheet. They do…
Hi. I have a sheet where I am sorting dates by ascending order. But the sorting functionality doesn't seem to be working. Instead of bringing all items with date values to the top of the sheeting and sorting them in ascending order, it leaves a gap. Is it a result of the "Next Review Due" column containing a column formula…
Good afternoon, Recently we have started one of our sheets in Card View and on a handful of occasions, we have had users deleting cards (or rows) from the sheet, simply by clicking the delete button on the keyboard by accident. I have done a manual test on a copy of the sheet and doing so does not prompt the user to ensure…