-
Parent row inheriting status from its children
Hi. I have a number of children rows for each parent. The child rows each have a "Status" column which is using the red, yellow, green icons. I'd like the parent row to inherit the worst case summation of the child rows. E.g. if the child rows are red, green, and green, the parent row would show red. E.g. if the child row…
-
Live Dashboard Presentation
Hi all, I am needing to present a few of my dashboards, in real-time, on a 24 hour cycle. I will be presenting about four individual dashboards but I am running into a bit of a snag. I tried using Revolver Tabs in Chrome, but when the tabs rotate it auto-refreshes the new screen which causes the full screen mode to…
-
CSV Export
I don't see CSV as an export file format option. Does anyone know if this is possible or coming anytime soon? Thanks, /mark
-
@ notification has a hard time finding email address
I love using the @email-address to send notifications to my team - thanks for adding this feature. We have a large organization and I find that when I begin to type someone's email, Smartsheet presents a huge list of potential emails and it is challenging to find the right one since I do not have these email addresses…
-
Help with Bulky Formulas/Formatting?
Hi all, I'm fairly new to smartsheet (with no Excel experience either). Here's my situation. I'm tracking POs-- first, you enter in a PO amount, and in subsequent columns what you invoice per-month. There's a final "Totals" column that sums up your monthly invoices. Currently, I have a hidden column set up to test if PO…
-
Checkbox condition in a child row, conditional formatting of parent?
I have an uber parent row that is the mother of a group of related tests for software QA. In addition, some of the children of that mother have their own children. I would like any parent row to turn red if any of its children fail a test, as noted by a "Fail" checkbox column, and bonus points for conversely turning green…
-
Resource Allocation
Greetings, I am new to the aspect of resource allocation. I need to know apart from people can objects (computers, scientific instruments etc) be allocated as resources, as I need to keep a tab on the overuse of certain equipments at my organisation. Next, can only people with licensed accounts be tracked as resources on…
-
card view filter - include summary tasks
I commonly have task lists that are nested to an arbitrary number of levels. In card view, you can filter tasks to level 1, level 2, etc. This isn't very useful to me. I think it would be far more useful to have a filter "include summary tasks (or not)". Since my actual tasks are always on leaf nodes of the hierarchy, by…
-
Changing column Property Status (Red, Yellow, Green) when two columns dates are different
I am in need for the status colum 1 (red, yellow, green) to automatically change when column 2 (date) is passed column 3 (date). Can this be done with a formula? I can do "=IF([Approved Required Delivered Date]1 < [Adjusted Delivery Date]1, "Red")", however, I am sure on how to add the other two conditions in the formula.…
-
time calculation
Hi there, I am a newby here and I must say that smartsheet looks good. The only thing I am definetly missing is a way to calculate time This is what I need to show: Start End Duration h Price per hour Price total 09:00 10:30 1,5 100,00 150,00 Start and End time can be put in manually Duration must be calculated…