-
Conditional Formatting
Hi all, and thanks in advance. I was trying to do a Conditional Format on this. I know how to do it in Excel, as I would use a formula, but I am having trouble with only the dropdown choices available. Okay, I want my CF to check if the 2 circled columns are the same. This instance does not show, however basically I am…
-
Intermittent Errors on Column Formula, Report always displaying errors
Why is my sheet intermittently displaying error messages & Report always displaying error messages. One minute the columns have data then randomly they all show up with the error messages? My report consistently ONLY displays error messages. I have a sheet performing calculations related to consumption of water based on a…
-
Formula to Pull In the Sheetname to A Cell?
Hi all. Is there a formula or a way to pull in the name of the open sheet, into a cell on that sheet? Ideally I was thinking something like =sheetname but that's not an available formula.
-
Best way to cross-reference multiple sheets for repeated values only?
Hello all! Looking for some advice here. I have multiple sheets that track guests invited to events (5 right now, but it will continue to grow). I want to create a something that references them and lists only people that have attended more than one event and which events they have attended. So for example, let's say on…
-
range checking & flags
Hi, I'm trying to leverage a formula to check if the employee ID is listed on another sheet. Sheet 1 (sanity check): This is where I want the formula to live. On sheet 1, if the employee ID on the row is not listed anywhere on Sheet 2's Employee ID column (range), then turn the flag on. If the employee ID on the row is…
-
Flagging rows based on number of occurrences within a range of another date
I have a sheet where I want to count the number of occurrences of the same [PI Name] within a 30-day period [Sx Date]. I only want to count each PI once on any given date. I've given an example below to show how I want the counting done, but the solution can look different from this. Whatever solution I use will have to be…
-
Collect from another sheet
I want to populate a date in sheet A based on the min date in a list of dates on sheet B. What is wrong with this formula: =MIN(COLLECT({REWORK Sprint Dates Range 1}, {REWORK Sprint Dates Range 1}, >=[Start Date]@row ))
-
Trim Leading/Trailing Spaces
This is pretty basic but I'm not sure what formula to use in Smartsheet to trim any leading / trailing spaces from values that are entered into cells. In excel this is a simple TRIM formula but there doesn't seem to be an equivalent in Smartsheet. I've tried the formula glossary and AI but unfortunately I'm not finding the…
-
Budget - Sum total of a specific category
Hi! I'm working on a simple budget sheet and I'm having difficulty with a formula to sum total a specific expense category. I want to sum all expenses in a given category from another sheet. This is what I have so far but it's pulling back $0.00 despite their being items that match the criteria. =SUMIFS({Expenses Range 2},…
-
Automation to Move cells without individual logic
Hi Smartsheet Community, I’m looking for assistance with optimizing our workflow for our project intake process. Here’s our current setup: All project requests come in via a single intake form. They populate into our Prioritization Tracker Rows are triaged as Declined (move to Declined sheet), Backlog (move to Backlog…