-
Automation to Add Row
Is there a way to use automation to add a row to a sheet every morning with a new date and the checkbox fields? I have created a sheet for daily tasks, where each row is a new day, however, I don't want to have to add a new day each morning, and simply added all the days of the year is not possible. Can add a row be…
-
Sheet Summary Date Conundrum
I have created a sheet summary. I am adding a new field to reference a single date in my Smartsheet. I have attempted using the following function =([End Date]279) and am getting a #INVALID COLUMN VALUE display. After trying various types of formulas, I am at a loss. All I simply want to do is pull in a specific date that…
-
Searching across three columns and if match found, then return info from a date column.
So I'm attempting to create an inventory rental sheet where the end users (front desk techs) can enter information on a "Checkout" sheet, and that information can be checked by our main Asset inventory sheet and return the checkout date to the main Asset inventory sheet. Problem is we have multiple types of rental assets,…
-
Set Parent's Projected Date based on Children's Status and Projected Date
I am using several layers of parents + children rows, and I need the duration / projected date to be "TBD" when a child row is "In Progress" or " Not Started." Here's the current situation - when a child row has a date set, it rolls up to the parent, which is inaccurate as a projected end date since there are still items…
-
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…
