-
How do I limit the number of entries under the same company name
I have a list of companies that are allowed 2 complimentary registrations. I want a notification sent if a third registration is added that tell the company rep they need to pay for the third registration. I have a list of company names with the contact information. I then have the registration list with a form forā¦
-
COUNTSIFS does not Contain
Hello, I've put together the following formula, to count certain items in a different sheet that don't meet certain criteria, please see below. =COUNTIFS({SE-Region}, Region@row, {Status}, <>"Completed", {Status}, <>"Canceled", {Status}, <>"Duplicate", {Summary}, <>CONTAINS("Onboarding", {Summary})) The formula works untilā¦
-
Need help with an Index/Match using TEXT for Dates
Can someone help me understand how I can correct this formula? It's returning Unparsable. =INDEX({Revenue & Opex | ARRONI Row}, MATCH(TEXT(DATE(YEAR({Revenue & Opex Go Live Date}), MONTH({Revenue & Opex Go Live Date}) + 11, 1), "MM/DD/YYYY"), {Revenue & Opex Date Header}, 0)) The formula is indexing a full row. Matching aā¦
-
Iferror using multiple sheets
Hello, I have a sheet titled "4G Cradlepoints" with the serial number in the first column, Column name is "Serial Number". Each serial number is listed once. I have another sheet named "All Sites" and the 60th Column is named "4G Cradlepoint SN". The serial number will be listed multiple times in the "All Sites" sheetā¦
-
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
-
Formula to remove the 'd' from "Days Needed" rollup number relinked into my summary Sheet?
Hello! My company needs to determine how many Total/Average days it is taking our team to complete our projects. We use Smartsheet Project Schedules. And at the top of each project schedule is a 'Days Needed' roll-up. In a separate sheet, I am adding/cell linking all of these 'Day Needed' roll-ups. In this separate sheet,ā¦
-
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ā¦