I am tracking target start and target end dates within a sheet. I'm trying to derive each month that a project is actively being worked on (so if the target start was 2/1/22 and the target end was 4/3…
Is there a way to send a weekly email reminder to specific people? They are shared to the sheet but I don't want the notification to go to everyone shared to the sheet.
If I share a report to someone outside of my organization but it shows up blank, what am I doing wrong? They are not shared to the underlying sheet - is that the problem? Is there a workaround?
I have a main sheet I use to gather information from underlying, linked sheets. Is there a way to get my base sheet to update with modified by date of those underlying sheets? (i.e. I have one sheet I…
I'm trying to update a dashboard to show a pie chart with green for "Complete" status, yellow for "In Progress", and red for "Not started". Not all of these statuses are currently chosen for the lines…
How do I use a formula in my parent row to update based on the children's status? I want the parent row to to "Active" if any of the children are "Active", "Complete" if all of the children are "Compl…
Can you create a chart based off the sheet summary formulas (written and stored in the right hand pane)? I can figure out how to create a metric on a dashboard but can't figure out how to create a cha…
Is there a way to create an alert based on numerous dependencies? For example, if Bill Smith needs to be notified only when both tasks 1 and 2 are complete, is there a way to do this?