-
Index/Match Formula Referencing Contact Columns Providing Wrong Values
I need help with a formula. Since there is no way to cross-check against a group in a sheet, I have created a sheet listing all users of a particular group and am trying to use a cross-sheet reference formula in my intake sheet to be able to identify when a requestor is not already in the group so that I can add them for…
-
conditional format
Hello maybe someone knows if it's possible to define condition format by using a formula in condition as it can be done in Excel For ex if I want to define a green color for KPI value if it is more than 95% from the target ' without specifying the additional calculated field
-
Toggle Buttons for Entire Dashboard?
I have an dashboard built and want 4 buttons to toggle between different possibilities (1, 2, 3, or 1 2 & 3). Is there a way to do this?
-
RYGB Based on two date columns
Hi All, I have a formula that I can't get right and looking for help with the following: Green Status = If End Date is in the future and Status is "In Progress" Yellow Status = If Start Date has begun and the Status is "To Do", Backlog", or "Planning" Red Status = If End Date has passed and the status is "In Progress" or…
-
Move Row automation stops working when there is a row deleted from the sheet
We have put a condition where one of the column has a dropdown change, then move the entire row to a different sheet. However, we see that the Automation had stopped working and while performing a troubleshooting exercise, we found that when a user deletes any rows from that sheet where the automation lies, the workflow…
-
Countifs in multi contact column referencing another sheet - Help!!
Please help, i am trying to count the total times each name appears in a multi contact column within 365 days referencing another sheet… where have i gone wrong? =COUNTIFS({Archive T&F Date}, <=TODAY(), {Archive T&F Date}, >=TODAY(-365), {Archive T&F Presenter}, FIND("Jen McFarland", @cell) > 0)) It seems like the @cell…
-
If Project name column CONTAINS specific text
Okay I have 2 columns, one contains a unique number (left) and on the right that unique number is listed with the program. I have been able to accomplish this so far, however I ran into a little snag. There are some programs that contain JNEEO, and their unique TDL #. However, once I added the formula I discovered not all…
-
IF(MAX(COLLECT formula issue
Hi, There's an issue in one of my sheets and I can't find what the error is, so I'm hoping somebody can help me please. I have an electric meter submission sheet and a metrics sheet where the data goes into. I have the below formula, which works perfectly for previous months, but 0 value displayed for the month of…
-
Return multiple values from one search criteria
Hi! I'm fairly new to Smartsheet formulas and have reviewed the community posts trying to find help to my question. I am trying to pull PTO requests from one sheet to another. VLOOKUP has always been a friend, but unfortunately does not pull multiple values. My lookup criteria is a single date, (ex 2/28/24) but there can…
-
Help with formula to count multiple select in one cell
HI! I am hoping to leverage the collective brain power of other smart than myself. I am trying to create a formula via my cross sheet that will count the number of times a contact appears in a cell. What would be even more awesome, would be to count the number of times that an option is within a cell AND the status of that…
