-
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.…
-
Sort order affected by other users
Hello team - I am one of many users that updated this sheet on a minute by minute basis. Every time I do anything, I update the sheet. Problem is that even thought I've set up a filter so that I only see the items is want to see, whenever another user sorts the columns, my view get's sorted too. It makes it very difficult…
-
Change a row "owner" using a contact list and notify only them
Hi, I have tried to search before posting, though didn't find a specific answer within a sensible time - so hopefully I'm not repeating a request /question. If I have a task sheet with a field set to a contact list that's used to denote the row owner, is it possible to set an alert that when this field changes from user…
-
Copy and paste text from email
I have a smartsheet set up for RFI's (request for information) on a project. If somebody sends a query by email, how can i copy and paste the text from the email into the smartsheet ? I copy the text but 'paste' is greyed out when i try to put it into smartsheet ? Urgent help needed please so i can pack up for the weekend…
-
Collapsed Child Rows Attachments Displayed in Parent
I searched and did not any information on if there is a way for attachments in child rows to be visible via the parent row when the section is collapsed. For example, an employee posts pics to the child, but we thought the project was done. As the project is collapsed no attachment is displayed unless we uncollapse the…
-
Dependancy
Everytime I am attempting to change my predeccssors type (Finish -Start/finish-finsh etc) it tells me there is an error. "Circular Dependency". Can someone please give me a sample of how to setup? Thanks
-
Color format
Hi - I just noticed recently that the format in some of my columns changed. The font changed to white and I cannot see what is in the cell. I only see a faint outline of what's in the cell. I selected the entire column(s) and tried to change the font back to black but to no avail. Some of the cells have black font others…
-
Automatically linking cells/sheets
I want to create a sheet that will automatically add any task that has been assigned to me in other sheets. Is it possible to set this up so it will happen automatically? I would like to avoid having to manually add every new task I am assigned from every project I am working on. Ideally I would like to set this up for my…
-
Conditional Formatting less than or equal to
I'm trying to setup conditional formatting so that when a cell has a value of less than or equal to zero, the cell will highlight. Unfortuantely, the is no 'less than or equal to' function. I tried to setup up two rules for less than zero and equal to zero but the problem is, the statements are linked by 'and' instead of…
-
ISERROR or IFERROR .....Please help
Hi Team, Starting to expand my SUMIF formula which is great. The only issue is that it returns #INVALID DATA TYPE, when the [Sold Date] cell is left blank. I need to add a (ERROR formula in there somewhere im guessing. Im not sure excatly how ???? =SUMIFS(IFERROR([Value of Jobs]2........ How should it look please ? Thank…
