-
Sight Cell Linking
I want everything that is under a Parent Row on a Sheet to show on our Dashboard. Is it possible to cell link ALL children under a parent row to a Sight/Dashboard? Examples: If any rows are added they will be included If only one row is populated, only one row will show in Sights
-
Creating a cell link to a different sheet with different working days
Dear community, I have created a sheet for Data Center migration planning. By definition these activities are planned during normal working days (Mon-Fri) but the migrations happen during weekends, as it requires to stop servers and so that's the lowest impact to services. This sheet has defined all days as working days to…
-
Constructing User-proof formula
Any ideas on constructing more user-proof formulae? I'm having trouble with users inserting rows in a sheet versus appending new rows at the bottom. Locking rows doesn't prevent an insert (would be nice if a non-admin user couldn't insert when adjacent rows are locked). I've used the following formula to ensure the first…
-
Summary Cell on a sheet that auto-adds form entries to the top row
I have end users submitting forms and the entries are automatically added to the top row. I don't want managers to have to do any sort of parent/child indentation work after forms are submitted, so I've added a column where I have calculated the max value of a very important column and just copied that value all the way…
-
Hide Parent Rows
How do i hide or fliter out the parent rows in Grid View. Im trying to link only the data to any other sheet another sheet.
-
Starting time with predecessors
Is there a way instead of using a starting date, I can use a starting time? I have tasks to plan during the day for maintenance, this usually doesn't take more than a day. I want to use gantt view as well. I know the hour function has been added recently as I understand, so why can't I add up the hours starting from a…
-
cell linking for milestones
I have created a sheet for roll up of select rows only for sight using cell linking. I can't seem to get milestone icon. What appears as Milestone icon on regular sheet has come over to cell linked sheet as regular task. How do I get the milestone icon on the cell linked sheet?
-
Best practices for managing offshore team task and schedule?
We need to overcommunicate and manage our offshore teams better. What are best practices in terms of tracking and managing ALL the schedule and tasks using Smartsheet? One master schedule containing the details of every task (which we want individuals to go in and update status with comment)? Or separate the schedule from…
-
Trying to Sum Rows of linked cells
I'm new to Smartsheet and struggling with a few things, one in particular is wearing me out. I have several rows of linked cells that pull number values from another Sheet. I'm trying to Sum total these linked cells but the basic Sum formula doesn't seem to recognize these numbers. If I remove the Link the Sum formula…
-
Automatically add rows when report refreshes
I have a report that's running every day against a single parent row to grab totals. A few cells of that one, single, lonely row. I'm looking for a way to automatically copy the report's information into another sheet daily, that way, over a period of 1 week, 1 month, etc., we can see the changes in the totals. This is…
