I am currently creating a project template that I wanted to add some automation into. The first piece of that automation is to change the RGYB using the finish date and % complete. The formula that I currently have works great when you have dates in the cells, but that won't always is the case when
I am trying to share a report to users (not licensed) but can only get them to see the sheets in the report if I give them a license. I have shared the relevant sheets with the users.
Before we signed up to the paid account this was an option.
I have a column set up to indicate Task Progress (can choose from dropdown: Not Yet Started, In Progress, Nearing Completion, etc.) but also would like it to automatically mark "Complete" if another column (checkbox formatting) has a marked checkbox.
The issue I'm having is that the
I have the following if function (IF([Audit Start Date]3, ([Audit End Date]3 + 7), "Audit to be Scheduled") and I get Invalid data type.
the formula works when there is no date in column. However, formula does not work when there is a date in column.
I dont know what else to try. This formula
Hi there! I am trying to have it so that the flag shows if the End Date is 3 days away AND the Status is "Not Started" (ideally, I would like it to show if the status is anything but Completed, but that may be too difficult). I know to use a nested IF/AND function, but I keep getting errors when I
I have a status column that is being manually entered based on the days past due. I am trying to automate RYGB balls. I have gotten the equation to record what I want for Red and Green, however, I would like to have a blue one appear if the if the status is in queue. The problem I am running into is
I have an employee that stopped receiving automation alerts on a particular sheet. She receives them on other sheets and the others involved are still receiving them even though she is not. We have deleted the automation and re-added, we have deleted just her and re-added, we have created a whole