Hello All, I'm trying to create a cell formula that will highlight a task expired if any of its sub tasks are expired. For example if a parent task has any child tasks with due dates earlier than the one of the parent it should be marked as expired. Is there a formula available for this? Thanks
I have a task list organized in Card View, with conditional formatting to highlight critical tasks. Can I sort them in Card View to list the ciritical items first? Thanks, William
I am publishing a sheet in card view - but i have two lanes that have a gian amount of tasks in them - theses are the 'Not Started' itemes. I dont want to show those lanes when publishing. Possible?
Happy Monday! Is there any way to automatically collapse empty lanes in the card view? I like to show tasks in card view by owner, but we have a lot of possible owners which means scrolling to see all of the lanes when the task list is really concentrated on a few people at a time.
My AA left unexpectedly and I took over her role as administrator and owner or the sheets/reports she created. Problem is I can't get the color palette to come up to change the task bar colors no matter what I try. What am I missing?
The taskbars in my report calendar view aren't reflecting the taskbar colors in the underlying sheets, making it hard to tell which sheet the task is from. Anyone got any insight? Thx.
How can I force Card View to always show the field labels associated with data on all cards? I don't want to require users to click on the little caret symbol that toggles labels to display on each card... I want all field labels to always show on all cards all the time.
Is it possible to reorder sub-tasks within Card View? Instead of needing to go into sheet view to reorder the sub-tasks? Would be more convenient to stay within Card View to reorder sub-tasks rather than needing to switch to sheet view.
Hello, Card View is great. I wanted to start a separate thread specfic to card sorting and card column positions in Card View. Here are my initial questions. 1) What is the default sort/order within each column for cards in Card View? 2) What happens when a card is re-ordered, in the same column? 3) Is there a value that…
If you can filter by row which essentially hides data, then how might one apply these new filters to hide columns also? For example, I manage “reports due” and “proposals due” in one sheet. Report-related rows have 3 unique columns (ideal for Card view) whereas proposal-related rows have 5 unique columns and BOTH share 10…