-
Function Needed - Was this person listed in the previous week?
Hi @Genevieve P, I hope you are doing great. I have two issues that are related to https://community.smartsheet.com/discussion/70615/need-formula-is-this-person-listed-again-in-the-next-week/p1?new=1. Question: How can I get that red cell to say "Needs to be Activated"? Needs to be activated formula:…
-
Outlier Formula
I have a column labeled "Month Tenure" that has an outlier for of 215 which are the months that a staff member's been with the company, this staff member is on column labeled "Agents". Can someone please help me create a formula for this outlier?
-
New client vs. continued client
I have a sheet where I list all advice give to clients (each row is a separate entry for advice given to a particular client). I want to add a column that will tell me if the client is a new client or if the client has received advice before (calculating based on first instance client appeared on sheet). And then on a…
-
Formula to count the number of characters after a symbol
Hello. I am attempting to write a formula that will count the number of characters that follow a "-", and use the resulting number to determine if the type should be a "PO" or a "SWA" using an IF statement. I found a formula that will pull those characters following the "-", but it just gives me the actual 2 numbers…
-
Getting Message Column Formula Syntax Isn't Right
I'm trying to put the below formula into a column formula and continue to get this error: "The column formula syntax isn’t quite right, see our help article https://help.smartsheet.com/articles/2481944 for more information.". I've tried everything I can think of and it just isn't working. I've tried breaking it into pieces…
-
Count of free text cells on a dashboard
I have a projects list that is continuously being updated with a field labeled "location". How can I count the number of instances of each location to place on a dashboard. It's continuously changing so I cannot just put "countif" function.
-
Using a Vlookup and Sumifs in the same sheet ?
We have a master job list which we use to create our new project references. There are a lot of requests with a range of values ? I have a separate sheet where we populate with those projects we want to keep a closer eye on costs on picked up from other smartsheets ? The process being, I type in the job reference and it…
-
Health Formula
Please can you assist. I am currently using the SS Standard template Schedule Health Formula : Project Heath Formula =IF([Schedule Delta (%)]@row > 0.1, "Red", IF([Schedule Delta (%)]@row > 0, "Yellow", "Green")) My issue - Milestones which should not be are showing green because the Duration is Zero (see schedule formulas…
-
Need IF statement help
I am trying to build a formula using Duration to auto-select one of four statuses. Below is the formula I'm trying to build: If Duration is less than/equal to 30 days, then = "Transition" OR Duration is greater than 30 days and less than/equal to 60 days, then = "Reshaping", OR Duration is less than/equal to 90 days, then…
-
Formula fails after 1000 rows
Have this formula that works like a dream until I get to 1000 rows It basically creates a sequential number like this DM-0998, DM-0999. ="DM-" + IF(One@row < 10, "000", IF(One@row < 100, "00", IF(One@row < 1000, "0", One@row))) + JOIN(COLLECT(One@row:Two@row, One@row:Two@row, ISNUMBER(@cell)), ".") Once we hit 1000 rows…