-
Unable to Calculate Event End Time from Start Date and Duration
I’m trying to confirm if it’s possible to calculate an Event End Time based on our current fields. We have a report that we pull into Smartsheet On Smartsheet: Request Start Time (Duration) Duration (duration field in minutes) Event End Time: (Duration) Formula's that I tried: =[Event Start Time]@row + ([Duration]@row /…
-
RAG Roll-up formula
Could anyone help me with a formula I'm trying to perfect. I am trying to create a formula that automatically captures RAG status for Children Rows and how this is communicated to the Parent rows. The plan is essentially structured like this (images are attached): * Project Plan Summary (Senior parent)* Main Tasks…
-
Multiple Projects into a high level Programme / Portfolio Project
Hi Clever Community, Sorry to ask this question as I believe I've seen the answer but that was 4-5 years ago and I cannot find the article now. So I have 4 projects, each with a suite of smartsheets (all from a template) including risks, actions, milestones and timeline. So each of the 4 have the same fields and layout…
-
How to maintain permanent inventory levels when source data is deleted weekly
Hi all, I am looking for advice on the best workflow to manage inventory deductions. I currently have two sheets where Sheet 1 (Master Stock List): Contains hundreds of items, locations, and catalog numbers. Sheet 2 (Weekly Usage): Operators log items used during the week by scanning QR codes. Currently, Sheet 1 uses a…
-
What's breaking my task dependencies when using elapsed day duration
Hi I ran into an issue today where my smartsheet timeline was updated without any user's input and several dates were changed cascading to the entire timeline. I tracked it down to several tasks and started correcting them, realising that there is some issue when dependencies are using regular "day" duration and some are…
-
How to maintain permanent inventory levels when source data is deleted weekly?
Hi all, I’m looking for advice on the best workflow to manage inventory deductions. I currently have two sheets: Sheet 1 (Master Stock List): Contains hundreds of items, locations, and catalog numbers. Sheet 2 (Weekly Usage): Operators log items used during the week by scanning QR codes. Currently, Sheet 1 uses a SUMIF…
-
Move Projects in another Workspace/Folder with a Workflow
Hello Everybody, I am looking for a solution to move projects folders (control center) automatically after getting a milestone to another workspace or at least in another folder in a workspace. Is it possible? I don't have Bridge, but if I need Bridge to make this, I am also interested to understand how this would work.…
-
Sum if Multiple criteria matches across 2 sheets
Hi, I have two sheets containing a table of items. Sheet 1 is for entire item list and sheet 2 is for items used in a day. I want the sheet 1 to check the sheet 2 and reduce the numbers in the sheet 1 automatically. The problem I need to match two criterias. I tried following after making it work for one criteria. Any help…
-
creating mid-task lag?
In construction scheduling, we often have weather delays, lag when subs are working out of town, etc in which we need to create a delay mid-task. i.e., contractor A starts a task on 1/2, is delayed until 1/9 due to cold weather than picks back up and completes the task 7 days later than originally anticipated. Is there a…
-
Automating date tracking and reminders
Hello, Im building a long-range fiscal quarter date tracking sheet with preloaded due dates over multiple years . I need reminders to notify the assigned person only when the item is active , still unsubmitted, and within 30 days of the due date. I also want to avoid excessive reminder frequency. Also i want to generate a…