-
How to Have Children Rows Updated based on Data from Parent Row
I am setting up a sheet which will have many parent rows with many children connected to them. There is a column called "Escalated to AM?" which is a drop-down with the option to select "Escalated". There is another column called "Escalated?", which is a checkbox column. I want to add a formula to the "Escalated?" checkbox…
-
Counting with multiple criteria
I dont know what im doing wrong here, im trying to count anything with Mentoring and if Q1 is found =COUNTIFS({RelatedGoalWoW}, HAS(@cell , "Mentoring")) + COUNTIFS({Quarter}, HAS(@cell , "Q1"))
-
Split Multiple Selections In Single Form Into Individual Rows (Core Product)
There have been a number of people asking how to make multiple selections in a single form and then have those selections broken down into individual rows, and the previous answer was always to use a 3rd party app, a premium add-on, or the API. Below is a set of detailed instructions on how to accomplish this within the…
-
INVALID OPERATION ERROR - HELP NEEDED
Thank you in advance for your help. I actually worked with Smaartsheet's AI Help to generate and work through the formula. I have checked it twice and still get the same error message. Here is the formula: =IF(AND([Tester ID]@row = {DE2ET Tester ID}, [Scenario ID]@row = {DE2ET Scenario ID},…
-
How can I use Conditional Formatting for date in the past or future when a formula created the date
Hi Everyone, Thank you for your time in reading this. How can I use Conditional Formatting for date in the past or future when a formula created the date? The black columns are different dates generated. The 2 yellow columns are then selecting the relevant date based on different criteria. The white columns are me trying…
-
Help with addition to formula
Hi, i need to make an addition to the below formula please. I need to add if column type is issue and impact score is 4 - gray, 3 - red, 2, amber and 1 green =IF(AND(Type@row = "Risk", ([Impact Score]@row * [Likelihood Score]@row ) >= 20), "Gray", IF(AND(Type@row = "Risk", ([Impact Score]@row * [Likelihood Score]@row ) >=…
-
Users Submitting From Excel to Existing Sheet
Goal: I'm looking for a way for employees to copy/paste or upload new rows of data from Excel into Smartsheet without seeing the full sheet and ideally without needing a Smartsheet account. Project Overview: I'm building an expense report system where employees submit weekly expenses for review and approval. Currently,…
-
Help with INDEX/DISTINCT Not Working!!
I have the following formula: =IFERROR(IF(Auto@row = 0, "COMPANY NAME", INDEX(DISTINCT({Company Name}), [Row ID]@row )), "") Problem is - it has stopped working. It pulled out the first 115 vendors out of 425 items, and then stopped. Is there a maximum number of distinct items it will pull into a list? I do not see any…
-
Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
-
Automation change cell value no longer being translated to a $$ value?
Hi, I've noticed this issue in two of my smartsheet processes. I have an automation set up as follows: "When rows are added are changed and [Column A] changes to [Any Value], change cell value in [Column B] to "60" " I then set column B to be $ currency format. Up until recently, "60" changed to "$60.00" without issue but…