-
Duplicate Dates Across Multiple Columns
Hello, I'm trying to highlight duplicate dates with conditional formatting across various columns to avoid conflicts. Is there a simple way to do this? Sample Data is below. Thanks in advance.
-
Count # of Parent Rows in a Sheet
What formula can I use that simply counts the number of parent rows in a single sheet? My scenario: Each parent row is a different customer. I want to know how many active customers a particular PM is working with and link that number to a metric widget on the PM's internal dashboard.
-
How to Summarize the Assign to: Contacts in a Report
Hi There I see there is plenty questions relating to this topic, but what ever I try doesn't work. Here is what I'm trying to do: I want to create a Report on Multiply sheets. Each sheet has different Contacts assigned. Now I'm stuck on the Sheet Summarized Option. Here is my Screen Shot 1st Question - Under Summary Sheet,…
-
Vlook up Error
Hello Everyone I am using vlookup to return a contact card based on an email but for some reason, it keeps showing me #No Match even tho the email is found. Here is the formula for the Vlookup: and here is the ref table: I am using this formula in a different sheet and it works fine but it doesn't look at the email so i…
-
IF Formula for "ball color"
I am creating a sheet where you have to with a dropdown menu for each calender week (CW) in which you can choose between "fulfilled", "partly fulfilled" and "not fulfilled". I want to connect these field with another column where I use the ball symbols (fulfilled = green, partly fulfilled = yellow, not fulfilled = red) I…
-
How to apply conditional formatting when one date column approaches/exceeds another date column?
Column1 is Target Date Column2 is Current Estimate Can I make it orange and yellow depending on how far the Current is from approaching the Target?
-
Countif with Dates
Hi all, I've read notes on other posts with similar dates but haven't been able to figure it out so asking here. Sorry for the repetition. I'm trying to count the number of cells in a column of dates that have a date prior to a date I have stored in another cell. I'm actually doing it with countifs but I can get the other…
-
Due Date Automation for Tasks
Hello: I have 2 quick questions regarding how to best automate/populate dates for project management timelines. Is there a feature (or formula) within Smartsheets that allows you to specify if a task is a reoccurring item? For example, if on the last Friday of every month, we are to pull a client report, how do I set that…
-
3 condition formula- Help
Need help with a formula, 3 conditions- 1) Recognize first 3 digits of "ticket number" (EX: "LEG", "ONB", "REV") 2) Recognize when a task is past due 3) Status not "Complete" or "Not Applicable" What I have so far: =COUNTIFS({KIM- Project Plan- TEST Range 3}, "LEG", {KIM- Project Plan- TEST Range 1}, >TODAY(), {KIM-…
-
Countif Formula to include Flags
Hello, I have a cross-sheet formula pulling in dates and other data from various sheets; however, I can't figure out how to count if the column contains a flag. The formula is summing all new hires who have a status containing "push". =IF(Level@row < 2, SUM(CHILDREN()), IF(Level@row = 2, COUNTIFS({New Hire Push List -…