-
RANKEQ showing multiple 1 Ranks but still showing a rank of 2
I'm running into an issue using RANKEQ to determine the top 10 categories with some criteria while working with census data. The formula I'm using is: =IFERROR(RANKEQ([Speak English less than "Very Well"]@row, COLLECT([Speak English less than "Very Well"]:[Speak English less than "Very Well"], County:County, =County@row,…
-
VALUE function not working within longer formula
Hello, I am trying to get the value of a text for which the formula is: =RIGHT([program 1 Calculating 24 hr Hour value with date]@row, LEN([program 1 Calculating 24 hr Hour value with date]@row) - FIND(";", [program 1 Calculating 24 hr Hour value with date]@row)) Adding the value function to this isn't working even though…
-
Sheet Summary box COUNTIFS + AND/OR
I am trying to do something similar on the summary of a sheet.... I want to count if proposed start date column is less than or equal to today, as well as if the PC 2 column = one of "S1", "S2", "S3","S4","S5","S6","S7","S8","S9". I attempted by just trying "S1","S2","S3".... =COUNTIFS([Proposed Start Date]:[Proposed Start…
-
Column Formula Syntax Error - Subtracting Values from Current and Previous Rows
Hello, Need help setting up a column formula. Everyday, my team inputs multiple values into a row. My goal is to create a column that calculates the difference of a column from today's input vs the previous day. I am running into syntax errors trying to accomplish this (see attached image). Specifically, I want the PPM…
-
Countifs And/Ors
I am trying to count a specific series: Region1 + StatusComplete + Month series =COUNTIFS({Central HUB – 2019 Range 1}, [Primary Column]@row, {Central HUB – 2019 Range 3}, AND(OR(@cell = "2020-01")), {Central HUB – 2019 Range 3}, AND(OR(@cell = "2020-02"))) Formula only works with 1 Month, once I add the second month, it…
-
Unique names from a list of names
Is there any formula in smart sheet which can show all the unique name from the column containing various names???? I have tried many formulas mentioned in various discussion in smart sheet community but none of them are working properly, If possible, kindly share the link of discussion which can solve my problem or share…
-
Latest Comment Column - can we remove default name?
Hi Smartans Can we remove the name that would automatically appear in the Latest Comment column when a comment has been updated, or changing this to an initial instead of the whole name? Just checking if anyone knows any workaround to this. Thanks all! Syed
-
Is it possible to connect Sypro to Smartsheet?
Our client wants to connect Sypro to Smartsheet so they can only have 1 reference without duplicating/transferring the information from Sypro to keep from doubling the effort.
-
Counting Past Due Task excluding marked complete
Hi! Is there a way to count all tasks that are past due based off of date, but exclude tasks that are marked complete? =COUNTIF(Finish:Finish, <TODAY()) Can I add an exemption in this so marked complete is not counted? Please let me know! Branden
-
Add 1 Month to Date for Multiple Years
Hello I am trying to build a formula that will add one month to each cell as shown in the sheet below. When a new year starts however I get the error indicated below. Any thoughts on how to fix this are appreciated!