-
Update Parent Row based on Child status
Hi! I want the Parent row to automatically change with the most recent Child Row status. I currently do this manually so I have to update the status in 2 different rows. Right now I have this: =IF(COUNTIFS(CHILDREN(), "Open") > 0, "Open", IF(COUNTIFS(CHILDREN(), "In Progress") > 0, "In Progress", IF(COUNTIFS(CHILDREN(),…
-
Gestational age
Hi all, I'm sorry if this has been asked before, I can't seem to find anything on it. I'm looking to calculate gestational age- the age of a fetus in weeks and days using the due date for reference and a typical pregnancy being 40 weeks. I have it in Excel but I can't seem to get it to translate over. Any help is so…
-
Send as attachment - PDF + Excel ?
Hi Guys Another day another Smartsheet query - is it possible when sending a report as a scheduled attachment to send both the PDF & the Excel in the same email? Or is there a workaround in order to do so? Thanks! :)
-
End Date is auto-filled, how to stop?
Hi All, I have created a sheet for my team and outside of normal columns, we have an extra "Target End Date" to track if we meet target or not. Please see picture. However, the Actual End Date is auto-filled every time I enter Start Date with the default value of the same day as Start Date. It is very inconvenient, I am…
-
Converting a formula to a "column formula"
I am trying to convert this formula into a column formula. It takes selected cells from a row to populate the overall "Status" column. If tasks are "Not Started", the overall status will be "Not Started". The Same would apply for Cancelled. If all tasks are complete, cancelled or n/a, the overall status would be "n/a". If…
-
Activity Log
Is there a way to generate a report from the activity log? What I want to do is to be able to quantify actions being taken within a time frame (i.e.: one month of time). For example, I would like to be able to track how many lines were added to our master sheet - and how many were removed. I would also like to be able to…
-
Report Creation
Greetings, I am creating a report to check the incoming date of certain items for multiple projects. While creating it, only the parent row is getting imported to the report. Is it possible to incorporate the children rows as well ? The structure of my rows in the original sheets are as follows: Shipment of X for a…
-
Classroom Assignment
Hello, does anyone have or know of a solution for automatically assigning classroom space ? I have to build a sheet for the automatic assignment of classroom space referencing the registered number of students from another sheet, and keeping in mind the classroom space time availability so as not to overlap courses in the…
-
Formula for RYG for Project Schedule Status
We were able to create a formula for Green and Red status but have not figured out how we can automatically set the project status to YELLOW. Normally if an activity(s) are slipping that affects the critical path the project should be in a YELLOW state so a return to green plan can be worked on. So what I'm looking for is…
-
Multiple IFs then SUM
I have developed individual project sheets. In the project sheet I have multiple tasks. I want to populate number of hours I worked on each task, by summing the number of hours I worked on that project prior to a certain date. I keep all my hours worked on various projects in a work log which I am referencing from the…