-
Nested If with Multiple Conditions Automation for Project Management
Hi SS Community! Had a complicated question and my formula keeps coming back unparseable, so I wanted to run this by you and see if anybody could help me. Currently, I have this: =IF(AND([Start Date]@row < (TODAY() + 14)), NOT(OR([Status]@row)="Complete"), ([Status]@row)= "In Progress"),"On Deck", "Not Started") I just…
-
Sheet Summary Report - Want to edit fields within report
I created a Sheet Summary Report, and have found that the fields within the report are not editable, unlike a Row Report. In a Row Report, I can click into the cell directly within the report and update it. On my Sheet Summary Report, the cells in report are locked down and uneditable. Am I missing something in order to be…
-
Project Approval Received / Master Project Sheet Populated
I'm trying to setup an intake process where a new project is submitted through a form and appears within a project intake sheet for review/approval/denial. If approved, I'd like certain, if not all, column values for new projects to be copied over to a master sheet, which includes additional columns for project charter and…
-
HELP writing a multi-variable IF Formula
Looking for some help with automating a Health column with Red, Yellow, Gray, Green balls based on 4 corresponding values in a Status drop-down. But there are also some overrides that I want to incorporate and can't figure out. Back Log = Gray In Progress = Yellow Flagged = Red Complete = Yellow Override 1 Marking…
-
Sheet Roll-Up
I'm curious if there is a way to have a "higher level" sheet that pulls from other sheets. That way, each individual on our team can have their own projects with greater detail and our supervisor can see a higher level view of everything being worked on.
-
Autofill Monday based on a deployment date
Hi - I have a "date of deployment column" that I would like to auto-populate the column to the left to be the Monday prior to that exact deployment date which I will be calling "Launch week date". Also the the 3 columns to the left of that will need to populate 4 Mondays prior to launch week date, 6 Mondays prior to launch…
-
Report not Matching Formula Issue
Hi, I have created a report to use on a dashboard for showing the number of job cards to print for our workshop. The report is shown below, and you can see that there are different amount of jobs to be printed for each workshop: You will see on here that there is: * 3x for the FASTRACK Workshop * 10x for the Van Workshop *…
-
Move Row Automation
I am trying to create an automation that moves a row to another sheet based on a cell being changed to a specific value. In my case when I select a vendor to assign that project request to, I want it to move to a sheet that is their queue. When I create the automation, I get an error (below). Has anyone else had this…
-
IF / OR formula help
Hi community, hope somebody may be able to help. I am trying to link a % of completion column with a progress bar. Formula is as follows: =IF([% complete]1 = "0", "Empty", IF(OR([% complete]1 > "0", [% complete]1 <= "0.25"), "Quarter", IF(OR([% complete]1 > "0.25", [% complete]1 <= "0.5"), "Half", IF(OR([% complete]1 >…
-
Selecting Multiple Values from a Dropdown List
I have created a "dropdown list" column and added the values. I want to be able to select multiple values from the list. How do I do that? Thanks, Judith
