-
Subtracting Months from a date, Error #Invalid Value
I have three columns. One with a date 7/1/2027 in date format. One with a number representing the number of months I wish to subtract from the date column. Third column is a date column with the following equation: =DATE(YEAR([Column4]@row) - INT((MONTH([Column4]@row) - VALUE(Factor1)) / 12), MOD(MONTH([Column4]@row) -…
-
Allow Gantt view to use Date columns with Column Formulas for Start/End
I'm kind of flabbergasted that this is not currently possible in a Sheet, and I'm struggling to explain to my users why. It is already possible to populate a Date column with a Column Formula and then convert it to a Cell Formula, and then use that column as the Start/End for Gantt view / Project Settings, so the issue is…
-
Request Snapshot not received. I am the sheet owner. Not on spam/junk.
I have requested for a snapshot, but I have not received the email yet. Any idea why and what do I need to do?
-
Automation workflow not including attachments in notification emails correctly
Hi ! I am trying to figure out why some email notifications include attachments and others don't. I have a few teammates who add attachments to the rows when certain columns are triggered by a checkbox. I have my automations set below. And you can see once column was checked email includes attachment, but same email it…
-
Report adding and removing sheets
I have a report that consists of 27 sheets. Shared sheets and report with 3 people. These 3 people do not have the ability to add or remove sheets in this report. Is that normal? I would like for them to remove sheets as they complete a project. Attaching an image - the selection option is grayed out for them.
-
Tracking a 1-day project based on time not date
I am helping manage a 1-day Disaster Recovery exercise and we want to track the tasks by start & end based on time of day. Would also like to auto adjust the times with dependencies - Does anyone know if a template is available of has anyone ever done this before?
-
Create a user tasks sheet, but restrict users to only see their tasks
Hi I'm trying to work out the best way to assign and manage tasks to staff, where they can only see the tasks that are assigned to them. I'd like to create a single sheet where all tasks I create are recorded, but some of these tasks may be confidential and I don't want other staff being able to see all of the tasks…
-
Sheets disappeared
All sheets in my workspace disappeared unexpectedly; I am the owner and did not delete them. They are not in Deleted Items. I need help restoring them.
-
Automating Monthly Bar Chart Updates - Is There a Better Way?
I have a bar chart on an executive dashboard showing intakes assigned and completed by month and the bars are side by side instead of individual widgets for assigned and completed each month. Currently my process is: Add two new hardcoded COUNTIFS summary fields in my sheet summary each month (Month Assigned, Month…
-
Download List of Saved Automation Workflows into Excel?
Are we able to download a list of all our saved automation workflows within our workspace? We currently have many saved automation workflows within our workspace with some under sheets, some under reports, etc. and want to provide a list to our audit team so they can sign off on the new process. The only way they can see…