-
PTO Calendar
Hello! I have created a centralized PTO tracker that collects information about their PTO, including reason. I want to be able to create a calendar for each of our teams. The best way to do this seems to be via a report, but the viewer has to have access to the base sheet in order to view it. Because the base sheet…
-
Adding days from a date column
Hi, I'm looking to do a monthly, weekly and daily average figure for calls logged. Being as calls won't be logged every day of the year and there are personal holidays within the team to consider, I can't do this with a simple calculation. I currently have an automatically updated closure date column so in theory if…
-
Need help pulling distinct count from another sheet
Hi. I am creating a rollup sheet using two separate directories imported onto separate sheets. Looking for Unique NPI and Unique locations. The following formula works for the first entry, but is returning 1 for the next 3. =COUNT(DISTINCT(COLLECT({DE Location ID}, {DE Benefit Name}, "vision", {DE Client Name},…
-
Attempting to do an AVG using two identical sheets
I recently had to move from one sheet to two for one of my project sheets. Both project sheets are identical in setup BUT one sheet is the last three years (2019 forward) and the other sheet contains data from beyond three years (2018 and later). I've created a separate rollup sheet that I have been using but I can't seem…
-
Formula to get most recent status for a particular client
This is a repost of a question I ended up solving myself, but have run into another issue. Here's the setup: I have a "History" sheet that logs the results of form submissions: I have a second sheet, the "Summary" that should look something like the below image, showing the status of each category from the most recent…
-
Formula to Check How Many Boxes are Checked
I have a metric summary sheet that I am building to use as the point of reference for my dashboard. On my source sheet, I have a check box column for "Copy Needed." I want to count how many people requested copy needed when they made their request. So, ultimately, I need a formula that will pull back the total number of…
-
Conditional Dashboard Formating?
I have a sheet with several rows, and those rows may or may not have sales orders. If the row has a sales order then its booked, if it doesn't then it's pipeline. I'd like to have a dashboard pull data from this sheet that adds up all of the rows that contain an SO and also add up all the rows that don't have an Sales…
-
Counting Parent Rows
Good Morning, I have smartsheet Parent and Child rows. How do I count the parent rows? Also, how do I COUNTIF for parent rows that meet a certain criteria? Thank you so much for the help!
-
Column Formulas for Duplicates
Identifying duplicates with consideration of blanks This is the formula I am using to identify duplicates and trying to omit blanks and it is giving me a syntax error, can someone please help? Also, could I make this a column formula? =IF(ISBLANK([Folder Name]),"", IF(COUNTIF([Folder Name]:[Folder Name], [Folder Name]@row)…
-
Updating Approval Status Column based on two other Approvals
Hello, I have an "Approval" column that I want to automatically update to "Approved" if two other columns are also "Approved." I have tried different formulas, but am getting an error "Unparseable." My two columns that need to be in an "approved" status are "Executive Sponsor approval" and "Additional Approvers approval"…