-
Trackers feeding other trackers?
Hello, What is the best way to "push" rows of data from multiple trackers into one tracker? Suppose user 1 and user 2 and a Manager use their own trackers. The trackers follow the same template. User 1 and user 2 must report progress from their trackers into their Manager's tracker. They must report entire rows from their…
-
Change status automatically when selecting % done
Hello I have searched through the Help centre (center!) and I can't find the formula (if one exists....) that will automatically select the appropriate value in the % done when one of 6 choices from Status is chosen. So when I select Not Started, I would like 0% to appear in the % Done, Started=25%, In progress=50%,…
-
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…