-
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…
-
Image-Hyperlink
Wondering if there is a way to make an image as a hyperlink (Click on image). I have tested the option of adding image in cell, and also just add hyperlink with text, but I do not see way to actual make the image as a hyperlink. Thanks for any input.
-
Multiply total project cost by percentage to get sale price
Hello! This is my first post, and I know the answer is simple, but here it goes: I want to take a total project cost column and multiply it by a percentage that is inputted into another call, and have the answer populate an "Extended Price" column. Eventually I want to be able to add subtotals and do the same thing, but…
-
Link data into a cell out of an attachment
Hi, Is it possible to get a cell auto populated from data in an attachment in the form of a PDF or Excel? Our goal is to reduce manual capturing of data that continually changes. Y
-
Error When Saving Smartsheet
I have been searching the existing posts for something like my current experience, to no avail. This morning, I have been having trouble with my program management sheet. All of our current projects roll up to this sheet, and this sheet goes to my VP. It is large, but has always been large. I haven't changed anything…
-
Timesheets
My firm uses Smartsheet for timesheets and client billing. There are now 22 people filling in individual timesheets. There is a Client Name column with a dropdown box with all the client names, probably about 100 now. Monthly, I manually go into all 22 timesheets and update that dropdown box with new client names. This…
-
Schedule Cell Linking w/Lag
I have linked multiple project schedules together, but I'm wondering if there is a way to add lag time between the links? Currently the finish concrete completion date of the first becomes the clearing and grubbing start of the second, but I'm wanting to add a one week lag time between the two while keeping them linked.…
