-
Trying to Eliminate Unnecessary Automated Announcements
I have an active automated notification in a sheet of project tasks that lets the "assigned to" know when anything has changed in their row. However, they don't need to know about changes they made themselves so I am trying to eliminate those. I set up a column called "MATCH" and added a formula to check for a match…
-
Conditional Formatting in Rows Resulting from Formulas
Hello, This might be somewhat of a long/confusing one. I am trying to figure out how to better automate categorization for blood pressure categories when being placed into a sheet. For example, in the image below the column "BP" is where the initial number is input. I then put a LEFT formula in the column "Sys formula" to…
-
Separating Text Formula
Hello, I am trying to create a formula that will separate text. I can't use the Left or Right and the length of names is different. Example: I need to return the first name only in a different column. Format is LastName, First Name Full Name First Name Smith, Joe Joe Jones, Ralph Thompson, Leah Robbins, Sam Robinson, Sally…
-
Automation Rule: Change Status to In Progress Based on % Complete Between 1% and 99%
I’m trying to set up an automation rule in Smartsheet where the “Status” column automatically changes to “In Progress” when the “% Complete” column is updated to a value between 1% and 99%. I noticed that there isn’t a “between” function available when setting conditions in the automation workflow. What is the correct way…
-
Using Multiple Sheets as Resource Allocation Tool. Allocations not updating based on date changes
Hello! I am trying to use sheets in a resource management type of way without the complexity. I have two sheets I am using. Sheet One: Holds all the resources. It includes allocations based on dates. Sheet Two: Displays summary of allocation. I would like sheet two to update the Total Percent Allocation for each person…
-
#UNPARSEABLE error in sheet summary field formula
For my Customer ID column, I'd like to count how many cells have errors so I'm trying this: =COUNTIF([Customer ID]:[Customer ID], not(iserror(@row ))) The Customer ID column is a lookup from elsewhere, and typically the error that could show up is #NO MATCH. I've tried a few variations of this formula but can't get it to…
-
How do I keep parent child row structure when moving items to and from other sheets?
I am working on setting up recurring tasks for my teams timeline sheets. I have 2 sheets set up to help the recurring task functionality. My question though is around if it is possible to set something up so that when an item is marked as complete the parent and all child rows are moved and they maintain that structure?…
-
How do I avoid the cross sheet cell reference limit of 100,000?
I have several formulas that are critical to one of my dashboards. They reference a master sheet that grows daily in number of rows. I end up getting the cross sheet cell reference limit warning about every 15 days. Is there some way to easily mitigate this? I'd like to avoid reducing the size of the master sheet so…
-
Max out Cross sheet reference ?
I have an error message "unable to create cross sheet reference because this sheet already contains the maximum number of different cross sheet references." How to resolve this issue? I already deleted many rows to reduce the cross reference but didn't work.
-
Conditional Formatting on Task/Outline Level Formula
I want to format rows based on the Outline Level. e.g. 1 = a darker color, 2=lighter, 3=lighter than 2, etc. I am using a formula to calculate Outline level: =VALUE(COUNT(ANCESTORS([Task Name]@row )) + 1) However conditional formatting is not working. What could allow this to work? Thanks so much!