-
Separating data into separate rows, under the original an auto generated column number
My department has an existing SmartSheet, to track travel. This sheet autogenerates a number based off of a form submitted for approval. The issue is that in the form staff are able to list ALL travelers for the trip, which results in the names being included in one cell. However, I need to be able to have each traveler in…
-
How to set up an automation to link to a contact cell
Hi, I am using a project directory sheet for storing contacts. Is there a way to link other sheet automations to a cell in this directory sheet? For example, I want an automation to send a notification to an engineer. The engineer contact is on the project directory sheet. Currently I have to manually input the contacts…
-
Rank order people in a sheet by Date with additional variables
I want to create a column in my main sheet that will display the rank order (1,2,3,4,5, etc) of a subgroup of the people in the sheet. I will have these people displayed in a Report. This column will be based on 2 other columns from the sheet. The First Column defines the order of the subgroup. The column is called "Date…
-
Counting Dates less than 90 days from today
Hi there. I'm trying to write a formula that will tell me how may dates are less than 90 days from today. Here is what I thought should work, but it doesn't. I feel like I'm close. What am I missing? Here is the formula I have. =COUNTIF([Start Date]:[Start Date])@row, TODAY-90) Thank, Tony Cooper
-
Formula that calculates the multiple choices chosen from a drop-down list
I need a formula that calculates the choices from a multiple selections row. I am currently using the formula =COUNTIF({Link Access}, "Overdue Report")
-
How to COLLECT() a different reference value for each value in a multi-select column and SUM() them?
I have a cost matrix similar to this staged one: The cost matrix is referenced in a second sheet of "buyer requests" to determine the cost of their request based on the Type, Size, and Vendor they chose: When only ONE Type of Material is requested, the following formula works: =INDEX(COLLECT({Cost}, {Vendor}, [Preferred…
-
Please fix my syntax
Ok, I know it's something small but I can't see it. Can someone please tell me what is wrong with my formula? I'm getting an Incorrect Argument Set =COUNTIFS(Urgency:Urgency, "1 - URGENT Need attention today", Status:Status, "Pending (awaiting response)", "Working on it") tagging my formula guru @Paul Newcome
-
Smartsheet formula
I need a Count If formula to give me a count of only the cells in a column that contain Yes, No, and to not count N/A, and by Quarter.
-
Column selection for Sheet Summary formulas?
Hi Everyone, I am trying to select a row for a sheet summary formula, but it keeps giving me an #UNPARSEABLE error. It is working fine for other columns - however I notice on the ones where it is working the column range is linked, but not for the one I am having an issue with. Here is the one that is not working: Here is…
-
Is there a way to populate a parent cell with multiple data entries from Child rows
I am looking for a simple way to have a parent cell list ALL of the different data from Child rows as text. For instance I have a project listed as a parent row with each part on the project entered as a child row. There is a column with different notes for some child items. Is there a way to make the Parent row populate…