-
Automatically enter certain Text in a cell if Date Open > 60 days
I currently have 2 formulas that work in conjunction to look at Acct Open Date and if it's greater than 60 days it populates a column/cell with yes or no (via checkbox) then, looks to a SECOND column/cell and tells the first cell to enter the text that is in the reference cell. It works fine but it relies on me copying and…
-
Reference Sheet Summary fields in formula in sheet
I need to create a formula that concatenates (JOIN or "+") several fields in my sheet summary, back into a column in my sheet. What is the syntax I need to use to be able to reference sheet summary fields? Thanks!
-
How do I pull a count from a column by two other factors from one smartsheet to another sheet?
I'm trying to pull the number of publications that have been published by year, where the data live in three different columns. I want to pull that data to a different sheet. The formula I'm using is this: =COUNTIFS({R&D Presentations and Publications Range 1}, @cell = "Publication", {R&D Presentations and Publications…
-
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},…