-
How can I get a multi-select dropdown column to populate with comma separation?
I have a two different columns that are populating differently, just using simple formulae: (I took out all the error checking to make it simple until I can get it to work) =[Name]@row, where [Name] is a Contact list, allowing multiple contacts per cell, and =[Department]@row, where [Department] is a Dropdown list, also…
-
I need help with formulas
I am working on formulas to get approvals in one of my sheets - But there are more than 2 options and I'm finding it a bit confusing… IF both directors APPROVE = Trade Off Accepted IF one director APPROVES and the other one is PENDING = Pending Acceptance (Would I need two of these?) IF both directors REJECT = Trade Off…
-
Parent rolling up data in Children rows
Green line is the parent row everything inbetween is children rows Column 30 is counting rows from N/A column that are not ticked, which are the rows im looking for. so 6 rows are active rows which are being used. out of the 6 rows, 4 rows have been ticked in appoinment concluded column i want to roll up the count of 4 in…
-
Formula to Count Ages of Orders
I'm trying to create a formula that counts the open orders based on the date the order was created. The thing complicating the formula is that it's for a metrics dashboard, so I need it to count the orders that are between 1-3 months old, 3-6 months old, 6-9 months old, 9-12 months old and over a year. I'm at a complete…
-
Pulling data from one form to another
I am creating a sheet that will collect data from multiple regions through a specific contact. I currently do it through automation. When I fill in a specific region the email associated with this region is in the automation that I created and it populates the particular cell, and sends a form to that person. I am…
-
Referencing an existing field in a formula to perform a calculation based on the referenced field.
I am attempting to build a template where I only need to change one field, based on that field value, in my worksheet that will update multiple formulas in the worksheet. Is it possible to reference a field from within a formula that only using the referenced value in a particular column and row from the worksheet?…
-
Total Time Spent On Various Sites
Hi I have a sheet that tracks time spent on multiple sites, I'm trying to add this to a metric sheet but struggling to get the metric sheet to add the total time spent against each site as a total. Can anyone help with the formula for this? Thanks
-
Workday formula doesn't calculate correctly when value is "0"
Hello All, Having difficulty getting my formula to work properly when a column's value is "0". If the value is >0 it works fine. The formula is supposed to follow the WORKDAY variable and exclude weekends, which it does unless the value in the [Days to add] column is 0 at which point it seems to ignore the workday rule.…
-
Create a formula to calculate the price of comma delimited items in 1 column.
I have a vendor registration form that connects to Smartsheet from Google Forms using the Smartsheet Add on for Google Forms. When completing the registration form, the vendors can select up to 4 tables to rent and each table may have a different price. The form automatically created and populates my Smartsheet with the…
-
Formula to return value in another cell based on several criteria
I am trying to create a formula in column 1st yr (105 hours max) that will return the value in the Vacation Balance column ONLY IF the Years of Service is <= 1 years 11 months 31 days, AND IF the Country is USA OR PRI. I am using the formula below but it is returning vacation balances whose Years of Service is greater than…
