-
Formula to track duplicate text/values across multiple columns
Hi there, Apologies if this question has been asked multiple times but i have searched across the forums and cannot seem to find a definite answer to a problem i'm trying to find a solution for. I have built a tracker to track web activities across our site encompassing language, page that the activity occurred on along…
-
Prevent Cell Formula from being overwritten
I have a cell formula that will change the status of the parent cell (in this case Materials) to Green, when all of its children are either Green or Gray. However, since the sheet is shared amongst multiple people, it can be overwritten manually when someone changes the status to a different color then the properties of…
-
cant get IF statement to change value of another cell
I am trying to use an IF statement to change the value of "Ball in Court" based on the "PM question" cell: FYI - both "Ball in court" and "pm question" are dropdowns =IF([PM Question]@row = "02 - Changes Needed", [Ball in Court]@row = "01 - ENGINEERING", "") When I set "PM question" to "01 - Submitted" the formula doesn't…
-
RYGB symbol average Formula
Hello Everyone, I have a sheet with 13 different people filling it out with RYGB symbols. So I am having issues with creating a formula that will take an average of 13 people. Here is what I got so far and it's coming out unparseable. =IF(COUNTIF(Aaron@row, Chuck@row, Pablo@row, Lee@row, Oralia@row, Brady@row, Lowrey@row,…
-
Checkboxes to Generate List
Good evening! I need a little help to see if what I want to do is even possible. I am wanting to create a list of people based off of a response to a checkbox. For example, if someone completed a form with their name, address, and other fields to include checkboxes, and checked a box titled 6/7, I would want that person's…
-
Count of duplicates within the last 90 days
I need a formula to count the duplicate entries of 3 or more within the last 90 days. Then flag the row for a weekly report. I will group flagged row (clients) on a report. I was able to count the duplicates but need help with the formula to count if it fits the criteria of "Date Created" within the last 90 days. I have a…
-
Index Formula?
Hi Smartsheet Community, Our Legal team has a sheet which they use to track all of their deals. We recently implemented the Salesforce/Smartsheet Connector which is great except for one issue: there is no field in Salesforce for the Legal Reviewer. I'm now looking for a way to auto-populate that Legal Reviewer field based…
-
Setting parent value based on multiple criteria and multiple columns of children
Hello community, Ive scoured the forums, and found some similar questions, but nothing quite like what I need. I'm new at this app and forum, so please advise if I make a mistake in how to ask properly. I have parent rows, with an unknown number of children underneath. I'm trying to automate the status of the parent based…
-
If/then statements and automation
Hi team, I'm struggling with a request. Not sure if it's a Friday burnout or not. I was asked if we could populate one column of a sheet with a value if it could change the value of a different column. Ex: when selecting a percentage complete value (0, 25, 50, 75, 90, 100), would like for value selected to populate Phase…
-
Using IF and OR to Assign a Contact
I am currently using the following: =IF(Line@row = "Apples", {Contact 1}), IF(Line@row = "Oranges", {Contact 2}), IF(Line@row = "Pineapples", {Contact 3}), IF(OR(Line@row = "Red Grapes", Line@row = "Blue Grapes", Line@row = "Purple Grapes", Line@row = "Green Grapes"), {Contact 4}), IF(OR(Line@row = "Pears", Line@row =…