-
COUNTIFS for Escalation Tracking
I am looking to create a formula that counts the how many times over the last 12 months escalations of a certain deal size occurred. Deal size is represented as range of AUM in text format. The current formula I'm using is =COUNTIFS({Escalations Range 1}, "75M - 150M", {Escalations Range 2}, >TODAY(-365)) I created a…
-
Need formula to highlight row if same site # was entered within the week
Hi, My team currently works off a Smartsheet that tracks task e-mails we receive. Recently, we've been receiving a lot of duplicate items in our e-mail that we categorize with Task Subcategory "(TE) Critical Date Entry" on our tracker. Each e-mail corresponds to a specific site with a specific Location #. Basically, I'd…
-
Conditional Text
Hello! I am trying to figure out if I can do a sort of conditional text entry. For example, if I enter "St. Bernard" in a cell in column A, then the cell in same row of column B would auto-fill with the word "dog" but If I were to enter "Maine Coon" in a cell in column A, then the cell in Column B would auto-fill with the…
-
Creating Expiration dates based on products
I want to create a formula that will auto-generate expiration dates for individual products for an entire column. The sheet has a created date and column containing a dropdown list of products. The products have different expiration dates. Ideally I would like to format the expiration date column to have the product…
-
Creating Conditions that affect other rows
Hello, I am super new to smart sheets, but have done very well with 99% of what I have needed to accomplish, however… When trying to create a condition labeled "Yes | No," and if Yes is selected in that row, then I want it to highlight another row also in the primary column to red to highlight it being the next step to…
-
Need help hiding checkboxes
I have a handful of project intake sheets, that ControlCenter looks at to automatically generate project files if approved. We have 2 types of projects that are intermingled on the sheets, and use 2 automations in CC. I'm now running into an issue with some users checking both approval boxes, and CC generates 2 sets of…
-
Conditional Formatting Based on Modifier
Is there a way to do conditional formatting based on who modified /made changes into the sheet? I have multiple users covering projects and would like to be able to see who was responsible for editing each task. This particular workflow needs to use a horizontal schedule/flow versus a vertical one like most projects.…
-
Automation for conflicting events on same dates
Is there conditional formatting function available to trigger a notification in smartsheet when a date is booked for two of the same items? For example; in a scheduling sheet, when the same equipment is booked on the same date?
-
How to create a master sheet that can work-around the 20,000 row limit?
Hello Everyone! I need to consolidate data from two large Smartsheet sheets into one master sheet to use as a reference for another sheet. However, Smartsheet's 20,000-row limit prevents me from combining everything into a single sheet. I cannot use Smartsheet Reports as a workaround since reports do not support formulas,…