-
Counting filtered data
Hi - I have a question. I want to count the number of rows NOT BLANK after I filter the rows. Currently, the counting formula counts all of the rows even the ones that are filtered out. This seems rather simple but I could not seem to figure it out. Thanks in advance for your help! David
-
The smartsheet template for a yearly calendar mixes up Feb 29 for March 1-how to fix formula
I am using a template for a yearly calendar and it all works great until March 1st. Its a leap year and at that point it goes haywire. Feb 29 is not seen as March 1. Any suggestions on how to fix? Here is the formula in the row: =IF(MONTH(Date62) = 1, "January", IF(MONTH(Date62) = 2, "February", IF(MONTH(Date62) = 3,…
-
COUNT(COLLECT) Status and Dates
Hi Super Guru's, Could I kindly ask assistnace on where my formula is incorrect. Getting #UNPARSABLE error =COUNT(COLLECT(Status:Status, ="Complete"),[Finish Date]:[Finish Date], >=DATE(2024, 1, 1), [Finish Date]:[Finish Date], <=DATE(2024, 12, 31)))
-
Return value in a row when find fist value greater than zero or not empty on a different row
Need to convert below excel funtion/equation to smartsheet. Looking for the first value on a row greather than zero =INDEX(AI$23:BV$23,MATCH(TRUE,INDEX(AI55:BV55<>0,),0))
-
Displaying initials of 'created by'.
Hi, just wondering if there is a way to only display the initials of whomever created a rule, instead of full name. Is there a formula to do so, do I need to make a sub-sheet so-to-say to get that working? I am aware it has been suggested in column option and has been taken 'into consideration' by SS november '23 (or is it…
-
What formula do I use to reference a product name in another sheet by matching reference numbers?
I tried combining IF/MATCH/INDEX like this =IF(INDEX({Copy of Practice Fwd Sheet Range 3}, ="PRACFWD", MATCH([Firm ID]@row, {Copy of Practice Fwd Sheet Range 2}), 0)) in different variations but none seem to work. Some rows contains the same reference number but different products so I only want it to reference the product…
-
"Ask for an Update" not bringing in Contact List name
I have a column that is a Contact List. The list is correct, and everyone's email address is in there. I also have a automation for an update that would include the recipient having to enter/update the person in the contact list column. That part is working fine. But when the recipient submits the update the name is just…
-
JOIN COLLECT IF Statement
Hello Team, I have the below formuale which works just fine. However, I need to add a condition to this wherein it only picks those 'Program Status' which are 'Active' How do I add the IF Statement to the current string. =JOIN(COLLECT({Program Name}, {Project Health}, [Red Status]1), ", ") Thanks.
-
Pie Chart is Grayed out in Dashboard
I have a dashboard that was working correctly with a pie chart widget. Now the pie chart is grayed out and is no longer an option. The data does have values greater than zero so I'm not sure what the issue is. Especially since it used to work just fine. This is the formula I am using in my summary sheet to get a count.…
-
Formula incorrectly stating two cells are not equal
I have two columns, one is an index collect formula and the other is a simple subtraction of two cells. I want to create a formula to display a message if the two cells are not equal. I created the following formula '=IF([UOB QA]1 <> UOB1, "Check UOB")' and as you can see below, the two columns are identical and it's still…