-
Project Meta Data Formula
Hello, I am using the PMO template set and somewhere along the line while customizing my project metadata sheets started referencing the wrong cells in my Project Intake Sheet. They reference the correct row associated with the project ID, but they are not pulling the information from the right columns. I have checked allโฆ
-
Need Formula for Parent Row to Reflect Overall Status Based on Child Row
I'm currently working on a project tracking sheet, and right now I have a column with statuses like, "In Progress", "Completed", "Not Started", "At Risk", etc. There is a parent row with the project name and status. If any element of the child rows is "In Prgress", I'd like the status cell in the parent row to also say,โฆ
-
Function for finding the # of days between two dates
Hello, I am trying to find a function in Smartsheet that will allow me to identify the number of days between two dates. In excel, this function would be DAYS(end_date, start_date), but I can't seem to find a similar function in Smartsheet. Suggestions? Thank you
-
Could anyone help us create the proper formula? Parent/Children Health based off Due Dates
We are trying to utilize Smartsheet to list out, follow, and forecast our project schedules. The idea is that each Milestone of the Project is the Parent and the steps within the milestone are the children. We are having issues with the parents correctly representing an issue/delay within its children. Right now theโฆ
-
IF (And statement with date columns?
I have tried several ways including Not(isblank and now using the current as blank fields and ISBLANK, and 0s, now just with quotes... it won't read both coluumns. it is say complete, even if only one column is not blank. i have another column with a similar formula that works GREAT, but it doesn't involve date columns.โฆ
-
How to count number of projects in 2023 by current status
Hi, I created a Metrics sheet that feeds a dashboard last year that counted the status of a variety of items and it worked great when there was just one year. This year, I now need to only count the items that are for 2023. In the main sheet, I have a column that has the year in a string format (it's a formulaโฆ
-
File HASH
Is there a way to generate a file HASH (SHA256 or SHA512) of a file referenced in a cell?
-
Complex lookup and report data wanted
Good morning all. I have a complex procedure I want to try and accomplish. I have 2 sheets currently created. 1 is for our main invoice for a job, that has a payment schedule and a checkbox colum if the scheduled item has been invoiced. I have a second sheet that allows us to input all of the change orders, their amountโฆ
-
Newer to Smartsheet, trying to build metrics around ranges of data
Okay here is what is working for me: What I really want to count is this: as soon as I add in a range of criteria, it returns a sum of 0 - having trouble figuring out if there is a better way to write this out - the statuses are formatted exactly like this on my source sheet. Any help would be greatly appreciated.
-
Formula for only parent rows
I created a helper column to sum all the children rows under a parent row. I want to now create a column formula that only applies to the parent rows, that populates whatever is in the child row below the parent row into the parent row. I have it working if I apply the formula to each parent row but can't get it to work asโฆ