-
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 -…
-
Is a daily entry missing?
We use a form that allows each of our 120 stores' managers to input some data at the end of each day. Is there a way for me to see which stores missed a day? Each form entry requires the store name (drop down), and I have another sheet that has every store listed in it. Trying to think of a way to have a…