Want to practice working with formulas directly in Smartsheet?
Check out the
Formula Handbook template to view 100+ formulas, including a glossary of every function and examples of commonly used and advanced formulas.
Product questions?
Ask it here! The community's got your back.
Discussion List
Need help
Good Day! I need help to fix the formula below. I am having this error message: Incorrect Argument Set. Thanks in advance =IF(Phase@row; "Analyse/Conception"; IF([Date Requise DC]@row - TODAY() <= 10; "Rouge"; IF([Date Requise DC]@row - TODAY() > 20; "Vert"; "Jaune")); IF(Phase@row; "Exécution"; IF([Date Requise MES]@row -…
Countifs Function Not working
So, I've been working on this for a day. I have a headache lol. Can someone take a look at this formula and make suggestion as to what I'm missing? =COUNTIFS({Staff}, "Name", ({Event Type}, "Sale") I'm using 2 columns of data and want to do a count using Name and type of sale condition. Suggestion?
Trying to count values based on variables
Hi there - first question ever! Also - not great at using the right language so sorry if it's a bit confusing! I am currently trying to use a formula to count if a certain condition is met in column a - and in column b - to count it. so for example Column A (Role) Manager Assistant Officer Column B (Off Work) Yes No Yes So…
Return Same Vlookup for certain day.
Basically what im trying to do is a project tracker. When the guys do a project they spend a certain amount of hours on it. thats all good until the project is paused and restarted again i have a issue where it calculates off the closest date. So what I tried to do was if the project start was on the same day as the finish…
How To Compare Dates
Why does this: =if([End Date]7=TODAY,"Yes","no") return #UNPARSEABLE? And this: -if(and([End Date]7<TODAY, [%Complete]<100),"RED", "YELLOW")
Can a formula be entered into a date field and get it to stick
I have a sheet that tracks consultations. These are normally each row represents a single consultation. But occasionally we have a workshop where it takes several row to capture the consultations. We are using child / parent relationships to capture the rows related to the workshop. We use the top row as the parent and…
To change the value of another cell
I've searched this subject for a couple days now and I have seen this asked a few times but with their own request with specific technicalities like percentage of completion and such. Many answers include workflow or changing the cell in question to a formula which don't appear to be the answer here. My interest in this is…
Looking for formula
need to populate a date with these parameters. Defect type ="CRITICAL" - populates "clean up date" with date 5 days after "audit received date" but if Defect type = "major" or "minor" - populates "clean up date" with date 30 days after "audit received date" right now i have simple formula to populate Clean up date as 30…
The Average Number of Monthly Projects
I want to be able to have a formula that pulls the average number of projects we complete monthly for our sheet summary. I have a date column for "Date Completed". Can anyone help with what the formula would look like?
Date add 35 days
I am looking to enter a date 04/02/2020 and then add 35 days. All of our projects have a deadline of 35 to close. Would love any help.
Help Article Resources
Trending in Formulas and Functions