-
RBG and Gray Formula
Hi All, Can someone please help me correct this formula? The grey color is not coming up when the status is "on hold" and instead green is coming up =IF(Status@row = "On hold", "Gray", IF(Status@row = "Complete", "Green", IF([End Date]@row < TODAY(), "Red", IF([End Date]@row <= TODAY(14), "Yellow", "Green")))) Thanks
-
Rolling and Automated Inventory
Hello Smartsheet Community! I've been attempting to set up a rolling and automated inventory and have ran into a mind splitting concern. I've been able to set up a Master Inventory, Incoming/Outgoing sheet, and a Rolling Data sheet to speak to one another with notifications to notify when a currently stocked item needs to…
-
How to count if checkbox is checked
Hi, I need to count the total number of items that are in progress that are green but I only need it to count the ones where that criteria is met and a checkbox is not checked. I know the formula below works for counting just those in progress and green but I'm struggling to add the checkbox portion to it.…
-
Creating Charts from Checkboxes
I have a tracker that automatically checks a box if something has to be paid in a certain month (based on a separate date column). I'd like to create a bar chart on the dashboard to summarize the money due each month, but it won't allow me to select the checkboxes as a source on the bar chart. My workaround was to create…
-
Solution for extreme amount of conditional formattting
Hello!!! I have a scenario that has an extreme amount of conditional formatting requirements. if completed, the sheet will have over 10,000 conditional formatting rules. While hear there are not limits to the amount of rules, at 1,800 the conditional formatting dialogue box really doesn't want to open any more. Has anyone…
-
Max Collect Formula for Dates in 1 row?
I have read other help articles, tried writing with AI and still could use some help in writing a formula for the following scenario. I have three date columns. and want to return the value of the date that is the next date but in the future. if the dates were: 10/1/25, 10/10/25 and 11/1/25 it would return 11/1/25. This…
-
Error - Formulas reference too many cells
I have an automation (copy row to sheet B) that is failing. My error is attached. I investigate Sheet B, which is a large sheet, many complicated formulas, but my total count of cross sheet references is only 14. Does this mean there is a limit for the amount of intra-sheet cell references? If so, what is the limit, how…
-
Formula to change date from existing date column to the current year?
I have setup an automation to send a Microsoft Teams message to a channel whenever it's someone's birthday - and the only way I was able to do this was by taking the birthdays in the "Date" column and making the year this year versus the actual year the team member was born (if not, I wouldn't be able to set up a "when…
-
Ideas/workarounds for how to look up multiple values into multiple rows?
Hi Smartsheet Wizards. Bear with me, as I'm not sure about the best way to ask this question…! I have a "look up" sheet with thousands of contacts/email addresses and organization ID numbers. I need to pull out all of the contacts for a specific set of organization ID numbers. I have this set of ID numbers in another…
-
List of U.S. Federal Holidays in MM/DD/YY Format
I need to add business days to a date, and the guidance I'm finding on this seems very arduous and labor-intensive (and it's taking ChatGPT 10 minutes to come up with a list in the proper format!). What are you all doing to manage U.S. Federal Holidays in your Sheets for calculating business days? There has to be a quicker…