-
How do I update the Parent Cell so that anytime one of the candidates (listed in the Child Cells)...
is marked as "Hired" as the Status, it then doesn't count that row? For reference, see the first Parent Column "Accounting - 3 Openings" - however, there is only 1 opening that doesn't have the status as hired and it's not showing that...I tried to add conditional formatting to change the row to "Green" if status is Hired…
-
What's the best way to get a total count and also categorize the results?
I'm creating a dashboard for our team on submitted tickets but the requestor wants this data to show total ticket amount per team member and also have it broke down into completion dates. Ex: Jane Doe: Total Tickets 100 Completed 1 day or less - 50 Completed in 2 days - 25 Completed in 3 or more - 50 I'm pulling this data…
-
Dropdown list Default value
Hello, I have a dropdown list of 10 values, simply a Right First Time stat tracker. So they choose "yes" if the action on the line was done correctly, or choose one of the other 9 reasons on why it was not done correctly. Is there a way i can set the dropdown list to select "yes" as the default value? Thanks Andrew
-
Conditional Formatting Across Sheets
Hi, we have a Scheduling Sheet (with columns, wk 01, wk 02, wk 03, wk 04, etc). A Delivery Date column links into this sheet from another sheet. What we do at present is highlight the relevant week column based on the date in delivery date, so for example from Jan 2nd to Jan 8th is wk 01 this year. (See screenshot…
-
Merged: Full Sheet Conditional Formatting
This discussion has been merged.
-
Yellow if, Red if
Hello - looking for some assistance on a formula that I'm trying to create that will return my task health as Yellow if 1 - 13 days beyond target completion date, and Red if 14 days beyond. I have created the below, which works, however I'm stumped on where I need to incorporate the IF formula for Yellow, and how to ensure…
-
Could anyone help us create the proper formula? Parent/Children Health based off Due Dates
We are trying to utilize Smartsheet to list out, follow, and forecast our project schedules. The idea is that each Milestone of the Project is the Parent and the steps within the milestone are the children. We are having issues with the parents correctly representing an issue/delay within its children. Right now the…
-
Select the column in AJAX for Filter, Workflow and Conditionnal formatting
Hello everyone, Maybe I don't know how to do it that's why I prefer to ask the question before proposing an enhancement: Is there a way to search for a column just by typing the first letters of it so it shows up automatically in any of these section: Filter, Workflow and Conditionnal formatting Because today I need to…
-
Changing Status and Health Based on Percentage
Hi guys! I'm fairly new to Smartsheets (and project management) and i'm the first and only project manager at my company. I was looking for help with conditional formatting and and IF AND function. Any and all help would be greatly appreciated! What I'm looking to do is (seemingly) basic: If my "Percentage Completed" row…
-
Track Birthdays and Anniversaries coming up
I am trying to set up a dashboard to allow me to see upcoming Birthdays and Anniversaries, with them being sorted to earliest upcoming being at the top of the list. I tried, what I thought would have been to do a min collect, without luck. Then I thought maybe someone had a better idea as to how to make the happen.
