-
FORMULA: Conditionally Format Cells with Errors
This is unlikely possible with Smartsheet but I'd LOVE to be proven wrong :) I'm trying to Highlight Cells in the row that have errors. There might be one to twenty columns in that row with errors at any given time. Reason for it: One broken formula (or cell with bad data) can break several other formulas in that row. And…
-
Hierarchy Formula Help
Hi Everyone, thank you in advance for your help on this issue. Currently I have a level column that gives you a number based on the level of the hierarchy the row is assigned to. I am trying to implement a column called "Topic" that lists the Task Name for Level 0 of the hierarchy for all of the children rows. My formula:…
-
Need a conditional SUMIFS formula
Hello, I have 2 grids Grid A: Project Management (used for team planning and communication) Screenshot of Grid A Grid B: Invoicing sheet (used for billing clients). I need a formula to take the information in Grid B and tell me the sum of the rows in the Task 1 column IF the sent column is checked AND the void column is…
-
Help with Countifs & Contains formula
I am trying to create a formula to count the number of orders that are on hold. However, we have several hold types, so I just need to count any order that says 'hold' in the field. Here is my current formula. Can you help me figure out why it is not working? =COUNTIFS({Copy of Copy of LATAM Backlog Range 2}, "40 DEALER…
-
Changing draft start date based on value in a cell and the planned delivery date
I have a smart sheet with a planned delivery date of a communication and am using "T Shirt Sizing" (Small, Medium, Large) to indicate the scope and criticality of the communication. I want to calculate the date that the draft should be ready for submitted for review based on the T Shirt Size. I've entered the following…
-
Is there a solution for a v-lookup that is returning a NO MATCH for an auto number in another sheet?
This is an odd one. I have a source sheet Contract Tracker with an Auto ID column where I initially started the numbering sequence to include a suffix and then recently changed it only to be numerical. One a second sheet, I am entering the Row ID for select items from the source Contract Tracker and formulas are pulling…
-
COUNTIFS and SUMIFS formulas with multiple criteria AND a dynamic date range in a sheet summary
Hi everyone, I've had a look in the forum threads to try and find an answer already, but not sure what I'm trying to do is like-for-like with some of the suggestions. BACKGROUND: I'm helping colleagues with aggregating some of the data in their deployments sheet, which they use for managing and tracking their events, the…
-
Index/Match in different scenarios on same sheet
So far I've been successfully working with index/match to pull certain names (PM/Supervisor, Additional CC) when a certain requester is used on a sheet. Now I have a requester that is assigned to two (2) different clients, but the PM/Supervisor and Additional CC are different people per client. How can I incorporate that…
-
Identify Most Recent Record
Hello, I am using SmartSheet to log Training Records. Every time a record is submitted, I am recording three fields: Date, Name, Topic. Based on the date, I am projecting forward the next time training needs to occur. (ie: 3 years after most recent training record). This occurs in a "Renewal Date" Column as a column…
-
Make Single Line Form Entry into 18 Separate Rows
I have created a process using Helper Columns, Formulas and Automation that takes a 1 row form entry copies it into 18 separate rows based on the Sport Column and then copies those 18 rows into a 2nd sheet data sheet and then moves the entered row (Row 1) to an archive sheet. The theory was that when someone submits a form…