-
Conditional Formatting in Edit Mode
When using the "edit" (form) function on a row it would be helpful to have the conditional formatting show within the edit mode, so folks using the edit-form function can see the conditional formatting as it does not show up, or have a way to add "text" within the conditional formatting setup. For example - if I am using…
-
How to create either a conditional formatting and/or use IF(AND) Formula for Attendance Tracker?
So I'm trying to create a formula or create conditional formatting for attendance. Every 1 Unexcused Absence within 45 days is 1 Occurrence that must be documented with the employee. Every 2 late arrivals/ tardies within 30 days count as 1 Occurrence that must be documented with the employee. So if my employee was…
-
How do I use predecessors to ensure a portion of rows are complete before being able to go to the ne
I am wanting to use this format for pre-con to ensure nothing is missed or overlooked. I want to mitigate mistakes from our project managers to prevent project issues by not allowing them to move to the next section until the section they are working on is complete. We also want to use conditional formatting to have the…
-
FORMULA: Conditionally Format Cells with Errors
This is unlikely possible with Smartsheet but I'd LOVE to be proven wrong :) I'm trying to Highlight Cells in the row that have errors. There might be one to twenty columns in that row with errors at any given time. Reason for it: One broken formula (or cell with bad data) can break several other formulas in that row. And…
-
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…