-
Display Conditionally Formatted Data from an RSS Feed
Hello Community - I successfully created a SmartSheet that populates the Top Row with the most recent RSS feed data. This RSS data adds a new top row to my SmartSheet every hour. I created several formulas in the SmartSheet to display a conditionally formatted value (e.g. red, yellow, or green fill). I have about 10…
-
Max/Collect column formula not working
I would like to make this a column formula. The formula shown in the picture doesn't evaluate new rows as they are added. If I try to update the formula to be (=MAX(COLLECT([Your Bid]:[Your Bid],[Item # to Bid]:[Item # to Bid],[Item #]@Row)) or even (=MAX(COLLECT([Your Bid], [Item # to Bid],[Item #]@Row)) I get an…
-
Determining if all check boxes are checked.
How do you write a function to see if all boxes are checked on a row with multiple checkboxes? I tried using the SUMIF(Check_Box_1@Row = 1) and attempted to use a total number of checks to evaluate, but it does not like that. I tried using IF((checkbox=1 AND Checkbox2=1),"true","false) But that concept did not work either.
-
COIUNTIFS as an OR
Is their a way to use the COUNTIFS as an OR. Currently, it will count all conditions of a cell that match the conditions given. =COUNTIFS([Clothing Item]:[Clothing Item], "Jacket", [In Stock?]:[In Stock?], 1) will give me the count of all "Jackets" that are "In Stock" However, I am looking to count if [Clothing…
-
Select distcinct Email Address from Another sheet
I'm trying to get the distinct list of contcats (email address) from another sheet. I'm using =DISTINCT(COLLECT({Email Address}, <>"")). The email address is the entire column - not a cell range.
-
Sheets have Data Validation functionality?
Do Smartsheet Sheets have Data Validation functionality like Excel? I'm looking to preserve the order-of-operations and to ensure my automation triggers after users fill out 2 drop down cells, a text/number cell, and a checkbox cell. (The automation moves a row to an archive sheet, once the four cells are no longer blank.)…
-
Formula to return a value based on the current month in the SAME sheet
Hi, I'm having trouble getting this formula, I've tried a lot of options and am probably over-thinking it. In the image above, what I want to return is the 5% value. I have a helper row at the top under "12/2024", 5% relates to a value for the month of December. There would be columns in this sheet through 12/2024 and the…
-
Count if X, if not count Y, if not count Z
Hi All, I'm hoping someone can help me with my dilemma below. I have a form where people register for a training series (e.g., Series 1 (date/time)). Their response feeds into the "P&I Series" column in the screenshot below. I need a formula to count the number of participants who've selected that series and display the…
-
Hello, Novice needing formula help.
I have searched help topics but still find myself challenged. I would like the Date due cell to turn red if the Date Due has passed. Also, would like the Date Due cell to turn green if the Check In Date was before the Date Due. I basically need a visual reminder if the Date Due was missed and needs attention, but do not…
-
Need help with Health formula
Created a project plan with hierarchies. Created a column called LEVEL which gets a 1 if line item is a task ..this is working fine and I'm able to create reports. Created a column called HEALTH which gets a red/yellow/green ball depending on whether the task is overdue (red), on target (green) or some risk (yellow). The…