-
Conditional Formatting not applying to entire column, even with helper column added
Hi - I have a colleague who has a sheet with conditional formatting that turns the cell and text in a particular column GREEN if the date is within the last 31 days. As you can see below, only half the conditional formatting not applying to certain rows. I've gone and done the "helper column" trick and tried it that way,…
-
When Counting by week how do I only include the current year?
My formula for counting by week is: =COUNTIFS({BBS Data Range 1}, IFERROR(WEEKNUMBER(@cell), 0) = WEEKNUMBER(TODAY()), {Staff}, ="John Smith") This works pretty well but it is counting events that occured in previous years. I only want to include THIS YEAR in the count. Thanks in Advance
-
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…