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(COU…
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 an…
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 d…
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…
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 Start…
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 b…
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 incorpo…
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…
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 c…
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 projec…
