-
Visual Status Alert
Hello All! I hope this is an easy soulution. Can anyone assist me with creating at status alert based off of today's date and a start date? I want the Delay Status to automatically put the status listed and color the cell. If a Cleard to Start has a check mark, then it shows no delays and color coded green. At some point,…
-
Edit contact display?
Hi Do you know if you can edit the display of a contact in an assigned to column? Ideally I just want to see the initials in the icon and not the name/ email that follows. Thanks, Jo
-
Merged: Conditionally Lock a Cell in a Sheet
This discussion has been merged.
-
Set Target End Date first and have predecessors fill in
Is there a way to set the Target End date in a project sheet first and have all the preceding dates backfill? When I tried it, an alert comes up that says "…will result in the removal of all predecessor relationships in this row". I've looked into the Workback Schedule using the Project with Hard Deadline and Gantt…
-
Document Builder: Conditional Formatting & Symbols
It would be great if document builder was able to: either apply conditional formatting within the builder or carry through conditional formatting from the source fields/sheets able to pull through field properties such as symbols as the graphical representation rather than the backend text e.g. I want to include project…
-
Help with a formula
I am trying to get THe project column to auto populate with the "children" from the source sheet when the "sign Type" is selected.
-
Merged: Apply conditional formatting to a range of Columns or Rows
This discussion has been merged.
-
Request for Update Automation Logical Conditions
Hello, It would be incredibly useful to have the option to build a logical condition within the automation request for updates. Currently, our form is sent to our sales reps weekly for updates, but user errors often occur as they miss certain boxes. I am unable to implement the logic that if one box is checked, the other…
-
Combo a vlookup/index formula to pull a value from one sheet with cond formatting to another sheet?
Scenario: I have a Project A Plan sheet that has a field for Bill Rate and Role. This bill rate value is pulled in from a Client A Rate sheet via vlookup based on the value in the Role column on the project plan sheet. This formula is currently working fine. The Project A Plan sheet also has a column for employee name…
-
Daily PO Status tracker, with visual alert, if delay in any of multiple department's queues
Need to combine multiple department's reports into I'm assuming a dashboard that visually shows the status of the parts on order for the PO with status of the queues after flipped to an order. I can't figure out how to push daily status of the parts on order for the PO to a central report, but maintains the history of the…