-
Automatically add Child Sum to Rows
Hi there. I am working on several sheets that have a column called "Hours" which holds an hour estimate for task rows. I'd like for their parent rows to have a sum like "=sum(children())" so I can see how many hours are estimated for each project. My problem is that while I can manually set this for the rows, these sheets…
-
Help on using Lean Six Sigma Project Template Set
Hi everyone, I am thinking of using the Lean Six Sigma Project Template Set. I am a Master Black Belt but have not been fully utilizing the DMAIC project management, This is a great template set, but I have some questions. Is there a training somewhere that is specific to this template set? Thanks for your help. Freda
-
TODAY Formula Constantly Changing Date to Current Date
Hi - We have a formula in a sheet =IF(Status@row = "Closed", TODAY(), "") That when the status at the row changes to closed, it was to add todays date in the Date Closed Column. However, it seems that it is now changing the date for anything previously closed to the current date. We need it to change it to the date when…
-
Remove "Z" at the end of the date/time stamps in Seat Type Report date columns
The 3 Date/Time columns in the Seat Type Report include a "Z" at the end of the value (ex. 2025-11-11 00:07:27.000 Z). This prevents the field from being used as a date without manually removing it or creating a helper formula to remove it. Please remove the Z from the date/time in Last Paid Activity (UTC), Last Login…
-
Formula with date column weirdness
Hi all! Happy Thursday. I have a formula that I created that is looking to calculate a number of cells that meet the specified criteria on a particular cell that inputs a date when a box is checked through an automation. What I am noticing however is that the formula is calculating items that are earlier than the specified…
-
Time Tracking within Smartsheet
Our organization is looking to utilize Smartsheet for project management tracking and would like to have it track time entries to account for the whole week of work (projects and non-project work). I would like to know how others are doing this. I know Smartsheet has the Resource Management planning tool, but I have not…
-
Data Shuttle: Why am I getting this error and how do I fix it?
I download excel from sharepoint and upload it to smartsheet as a new attachment. It was working perfectly fine but about 20 days ago it started showing this error message. What is causing this issue and how do I fix it?
-
If Contains formula.
I need to compare a column that contains only week ending dates to a reference sheet that has a date column that could be any date. And also look for the word 'yes' in a range of words. And also look for the word 'weekly' from a reference sheet. All this to give a return of 'Completed' if true, and 'Incomplete' if false. A…
-
Why is the sheet name not in the browser tab when in Table view?
The sheet name is in the tab in Grid view, but not Table view, making it difficult to locate a particular sheet when multiple tabs are used. Is this a design oversight?
-
Limit on workflows triggering other workflows (aka daisy chained autoamtions)
I have a "Re-Release" process that is very long and complex. At one point in the process, a row goes through a series of automations that trigger each other. These automations copy the row to an archive sheet, move the same row to a "Re-Release" sheet, copy the ID# to an "Previous ID #" column, clear the data in over 60…