-
Designating who gets a back up email
Is there a way to change who gets notified of a recurring back up? Right now it states the workspace owner will get notified. Is there a way to designate who gets the email other than the workspace owner? Thanks, Paul.
-
Need to calculate an Expiration date
I have a sheet that I have included the current inspection date. I need to calculate two expiration dates. One column @ 90 days post the inspection date and one column @ 365 days post the inspection date. Any help would be greatly appreciated. Thank you, Nicole
-
Move Rows
Good morning! Searched around and don't see an answer to this. When moving a row from one sheet to another do all the same columns need to exist on each sheet, or will the move option simply populate the columns that do match between the two sheets? I think I recall that both sheets have to have all of the same columns but…
-
Automatically Adding Rows Based on Change in Another Sheet
I would like to be able to automatically populate rows in a sheet based on the change in status in another sheet. For example, if I have a spreadsheet of jobs I'm bidding on that has a column with dropdown options of "Bidding", "Won", and "Lost", I would like to have a sheet that auto-populates a row in a different sheet…
-
Project Approval Received / Master Project Sheet Populated
I'm trying to setup an intake process where a new project is submitted through a form and appears within a project intake sheet for review/approval/denial. If approved, I'd like certain, if not all, column values for new projects to be copied over to a master sheet, which includes additional columns for project charter and…
-
Material Tracking
Please help haha It is difficult to put into words exactly what I am trying to accomplish, but I'll do my best. Please ask questions if I'm not being clear enough. Example: I have a material column for material that is being delivered to a job site (Sheet name is Delivery Tracker). Each cell in the column is an individual…
-
Formula Help
Can anyone help with this formula? It works in excel but I am getting Unparseable error in smartsheets. =IFERROR(IF([QTY]@row,<>0,[QTY]@row*[Production Rate]@row),IF([Linear Feet]@row<>0,[Linear Feet]@row/[Production Rate]@row,[Sqft]@row/[Production Rate]@row)),0) Thanks for any help
-
How to add new sheets/dashboard to all existing projects on Control Center
I have created/provisioned a few projects on Control Center and realized that we wanted to add couple more sheets and dashboards to all new projects as well as to all existing projects. It doesn't seem like the Global Update can achieve this as it can only edit information within a template in the blueprint source folder…
-
How to "actualize" or transfer dependencies of a completed task?
Task A Task B is dependent on Task A Task C is dependent on Task B For some reason, I was able to finish Task B and Task A was getting delayed. How do I: 1. Extend duration of Task A without impacting dates, duration or status of Task B? 2. Mark Task B complete, such that actual completion dates do not change irrespective…
-
Multi-sheet Kanban
We use a checklist with 340 lines. We currently create a new sheet for each project. We would like to create a kanban that links these projects utilizing the highest level of the hierarchy as the lanes (5 lanes) and the next level as dropdowns in the cards (9 at the most.) The third level is where the actual tasks are but…