-
Vlook up
formulas are not my strength in SS. What would the formula look like for the below use case... I want to grab the date from when an agency was notified about an event being approved and the date when the agency contacted our sales rep about it from the form sheet into a schedule summary sheet with other relevant info.…
-
CONTAINS in COUNTIF referencing to another sheet returns #UNPARSABLE.
I want to count all the cells with the word "Exempt" in the Column/Reference {Stat}. Using the formula below gives me the #UNPARSABLE error. =COUNTIFS({BIN}, [BIN #]@row, {Stat}, CONTAINS("Exempt",{Stat}) =COUNTIFS({BIN}, [BIN #]@row, {Stat}, CONTAINS("Exempt",{Stat}@cell) =COUNTIFS({BIN}, [BIN #]@row, {Stat},…
-
Calculating % of a category for Circle Graph (Dashboard)
Hi, I need to create a circle graph or pie chart that shows my team the percentage of initiatives under each line of business. I'm using a metrics sheet to pull my data from, so the information could need to come from another (single) sheet. Basically, I want the graph to show x% is business code ABC, x% is XYZ out of all…
-
Placeholder for Start/End Dates
I've discovered that the % Complete column will only take into account rows with populated Task Start/End Dates - but this gives a distorted view of how much of the project is complete in the Parent Row. Is there a placeholder date or workaround I can use without making my own % Complete column using formulas?
-
Filter only children row when certain criteria is met.
Hello Community, What I am trying to do here is to display the milestones achieved by each client. The milestones are contained in children rows. The way to identify those milestones would be displaying the row with the highest date within its own family group and box check checked. Once I am able to filter the rows that…
-
Team Vacation Planner - automation to notify if too many people are taking the same day off
Hi there! Is there any way smartsheet can set up an automation that if there are too many people taking the same day off it'll send an alert to me? I have a start date and end date column I also have another helper sheet with each day (excluding holiday, Saturday and Sunday) in each row and different departments as column.…
-
Count of prior month dates
I am using the following formula to count the dates in this row that are equal to the current month. However, I am trying to make adjustments to this formula to count dates that appear in the prior month and keep getting errors. I believe part of my challenge is accounting for the end of the year. =COUNTIFS([First…
-
Subtracting Months from Target Date
Hello Smartsheet Experts, I really need your help as I have been banging my head against the wall on this one. What I am trying to accomplish I have a "Target Date" Column where a date is being listed as the Go Live Date for a new product. I have 4 seperate columns that I am counting down the time (Months) till the "Target…
-
Rank Values By Group
Does anyone here know how to rank values by group in smartsheet? In excel, it's done like this below.
-
How can I count by date?
I attached a screenshot of my sheet. I want to count the number of Block ID instance per date. Any tips? The end result would be a count of Block IDs in each cell that has a "Hierarchy Translation" == Date