-
Request for elapsed time in dependency lags/leads to allow for weekend work
I'm working with a biotech team and its extremely common that biological research activities can't stick to a regular 5d/40hr schedule and some tasks will end up on weekends. This can be done in simple cases with elapsed days (e1d etc). But frequently I need to set a dependency that's one or more days following another…
-
Folder structure and sheet naming convention
I've found the PMO template to be very useful, but I'm curious to hear from all of you about your folder structure and sheet/report naming convention when you're managing many different active projects. Do you keep the "Portfolio Level" and "Project Level" folder structure that the PMO template has, then just copy the…
-
Merging a large amount of data from multiple sheets
Hello, I am hoping I can get some assistance with this. We have a Work In Progress report that is currently housed in google sheets, but we are looking into moving it over to smartsheet. In Google Sheets, the report has 4 different tabs. All 4 tabs are in the same order (by project), but house different data on the…
-
Formula Help
Hi, I have a due date column and a status column. The different options for status's in the status column are - In Progress At-Risk Completed Postponed What I would like is a formula that can do the following - IF due date is empty or prior to date listed - mark status column to In Progress IF due date is within 2 days -…
-
Does anyone know out there, how I can copy and paste a list of contacts for approvers?
Does anyone know out there, how I can copy and paste a list of contacts for approvers?
-
help with formula's
hello new to smartsheets. i am looking to make a V lookup that will crosslookup on 2 sheet to tell me if it is on that sheet or not. this is what i come up with so far. =IFERROR(IF(ISBLANK($[Cable Name]@row), VLOOKUP($[Cable Name]@row, {K2 Power/Motor Cable List Tracker Range 1}, 1, false)) Motor, 0) I would like it to say…
-
Alerts Not Sending Even if Adding an Attachment is the Trigger
I'm trying to create an alert so that when someone attaches a file to a row, the attachment and row information gets sent to someone else, but I can't seem to get it to work. Here's the workflow set-up: I DO get an alert if a new row is added with an attachment, but I need an alert for a row that already exists. I DO get…
-
Conditionally select pictures for Document Builder
I've recently learned how to include pictures in Document Builder, which is phenomenal. However, I want to take this a step further and choose which image is attached to the row based on the content of another cell. Is there a way to do this? For example, I want Customer A's logo to be generated on the document when the…
-
How can I link my sheets in Workspaces?
Hello, I'm wondering if there's a way to link my sheets in workspaces, we want something that will transfer onto the other sheets or have something in red trigger another sheet into auto generating it there to know what task needs to be completed. Should i just do a master sheet and that will link them? or how can i go…
-
Multiple Drop Down Menus in one column
I sent this to Smart Sheet via Twitter yesterday: "I need to set up a template document which will have A. Description Column (permanent), B. Drop Down Selection (each line requires different drop down), C. Measurement column (manual input), D. Notes column. I will require to copy this document for each individual project,…
