-
How to link Task Start and end Dates to another project template file using a formula
I would like to update one task in another project sheet and have it automatically update on another sheet that showcases the more detail project specifics about that installation. I have thought about using the Index and Match formulas, but that would have to hard code the date and the date would be changing.
-
Best Way to Create a Stacked Bar Chart from multiple columns
I have a sheet that I pull into a report. The report I then want to use to make a stacked bar chart and put into a dashboard if I can. The columns I am trying to make into a stacked chart are: Lead, project and phase. The issue is that there are several leads and I need the stacked bar chart to show in different colors for…
-
Health and Wellness Solution
Good afternoon everyone. I am building a Health and Wellness Solution on my personal account to keep track of my health by logging things like; water intake, exercise (including type of work out, est calories burned, etc.), food intake, sleep tracking, weight log etc. Has anyone else done something similar using…
-
Automatically Setting a Future Date Based on Criteria
Is there a way in Smartsheet to automatically default a date column to 30 days in the future based on certain criteria? For example, if Column A has a value but Column B is left blank, can Column B be set to automatically populate with a date 30 days from today? I tried creating an automation where the trigger is when…
-
Need help with formula to pull list of chapters that are past due
Hello, We use very large SS and I'm trying to fully automate our status reports. In our Schedules for each chapter we have 3 rows of data, planned/revised/actual. I am wondering if it's possible to write an equation for each column that would do the following: Look at the same chapter number rows If the planned date in the…
-
Trying to sum columns based on value chosen from linked sheet
Scenario: I have 2 sheets: "AFE" and "Lines". There is a 1-to-many relationship between AFE and Lines (one AFE may have many lines), but I haven't set up parent-child in "Lines" because users will add entries in any order and I can't enforce any kind of sorting or parent-child relationship. In "Lines", there is a linked…
-
derive parent name into another column
I am trying to capture HRB in the red highlighted cell can you anyone advise on the formual please i am using the following but getting a blank =IF(COUNT(ANCESTORS([HRB LRB]38)) = 3, INDEX(ANCESTORS([HRB LRB]38), 2)) @Paul Newcome can you please assist me with this if you can?
-
Managing multiple due dates
Hello all, I need help creating a formula to select the most recent due date for a row. We currently have an automation that removes rows when the due date is past. Some rows have multiple due dates. We would like to enter all dates in one row, and have the sheet utilize the most current date to sort the row and then…
-
avoid pulling duplicate value
the above is a tracker i want to pull some value into the tracker i want to pull values from are show below: there are duplicate job numbers in the first screenshot but i only want to pull the value against one of them not all of them to avoid duplicate sums can anyone assist please? @Paul Newcome hi Paul, are you able to…
-
Date column auto update when changes are made
Hi, I have a sheet that lists a bunch of different sheets and workspace. On that line I have a date column when it was last updated. I was wondering, can I get that date column to auto update when a different sheet has changes made to it? Or somehow create a dashboard or report that mimics this.