-
Require a roll up $ value to be inserted into a Form
Scenario: our Form has 5 different product categories that our partners will add $ values for applicable product categories. Unfortunately, our partners will submit the form will all of the other information without inputting any values. Thus, internal team will need to reach back out to partners to resubmit. It is…
-
Sheet Compare to highlight differences
The ability to compare sheets that have a similar layout and list differences between them. I know using Control Center and Global Updates to rollout projects and project changes will solve this issue but I have current/legacy projects that were manually created. It would be awesome if I could compare sheets in an attempt…
-
Merged: Please allow access to create formulas from reports
This discussion has been merged.
-
Formula to change the color of a task name or date cell, based on another date cell
Hi all! Theoretically, I'd like to state: If the cabling will be delivered, but it won't arrive within 14 days before the date of installation, then change cell color of these tasks below to indicate the need to order temporary/alternate cabling solution. I realize it may be too dynamic to only be set-up in conditional…
-
Left, Right, Find, Formula Help!
I need help creating formulas to split cell information. One cell contains indexed information in this string format: FirstName LastName Email@Email 888-888-8888 I need the formula to split to each of these 3 columns FirstName LastName Email Phone Thank you!
-
List users based on criteria
Hi Smartsheet Community, I need to generate a list of names based on multiple criterias, can you kindly point me in the direction on how to accomplish this? How do I get a list of members in the Mgmt or Ops Team? How do I get a list of Managers with over 10+ years of experience? Appreciate your input! Thanks in advance.
-
Count Ifs Question
Hi Community, I want to use the countifs formula on a column that has multiple values (Ex: Apple, Banana, Pear). The cell is not restricted to one value, so some cells have multiple of the 3 values. When I use the countifs for "Pear", the formula is counting cells that contain ONLY "Pear". Is it possible to alter the…
-
Impact/target Multiple rows within the same group
Is there a way to impact multiple rows using a workflow? If I select "No", on "remote access" Column, I want the system to populate "Yes" on "was report delivered" column and today's date on when was the report delivered. "This is already happening successfully on my end" However, I want to target rows 3,4,5,6 with the…
-
Automatically Update Grandchild Status when Child Status Changes
Hello, I feel like I'm making this formula much more difficult than it needs to be (I'm totally overthinking it!). Anyway, I have a sheet that has Grandparent, Child and Grandchild rows. When the Child status changes to "closed", I want the status for the grandchild to update to "closed" Does anyone know any easy formula…
-
Index Match function for children rows on two sheets
Hi there, I am trying to index match on data in the second level children rows from Sheet 1 to second level children rows on Sheet 2, and am getting this error messages. Screenshots are at the end. Screenshots: Sheet 1 (data reference sheet) Sheet 2 (pulling data from source source sheet into this sheet) If I try to use…
