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
Help with CountIfs formula
Hi, I am struggling with a COUNTIFS formula. This is my metrics sheet where I am entering the formula. I am trying to calculate the total number of each Job Role with a Risk Status of "Active" or "Active - At Risk" or "Vacant" from another sheet. The job roles are in a column called "Role". I have tried a bunch of formulas…
UPDATE: Is there a way to ignore case in a unique identifier
UPDATE: I figured out something about my query below - not all of the doi's on the source and target sheets have the same case (some lower case, some upper). I think this is my issue, which presents a new problem. Is there a way tell smartsheet to ignore case? Or a formula to change case? I'm running into issues where my…
Summing data and applying parenthesis to negative value.
I need to sum 3 pieced of data, subtract a value and then show the value in a parenthesis for any that equal a negative value. I have seen a post about this formula, but how do I use this with the the other sum function: =VALUE(MID(ColumnName@row, 2, 10)) My formula: =SUM([Financials 2]@row:[Financials 4]@row) -…
ACOS Function does not exist
Hello, I have created a Smartsheet to collect operations data and I'm now trying to add a formula in there to automatically return a result using a formula. In other words, cell B1 and C1 get filled out through a form, and when that happens I want D1 to show a result using a formula which includes ACOS (Arccosine) and SQRT…
Highlight max values
I'm trying to highlight the highest value as well as the top 4 values in a column. Think of it as I need to identify the top 4 leaders in a contest
Duplicates formula
Hello I'm trying to find duplicates in the "Rest" column but since there are a few rows with blank spaces I'm getting a ✔ in the checkbox "duplicate column" the formula that I used is : =IF(COUNTIF(Rest:Rest, Rest@row) > 1, 1, 0) Thank you
Row referencing while cross-referencing sheets
This is my current formula in order to input the proper value from my master sheet. I am trying to change it so that I can drag the formula down (similar to Excel) and have the value of 1 update to 2 and so on. From what I have read it seems that the @row function is the answer to this problem but when I use the equation…
Create conditional formatting based on data
I have a sheet to track data for incidents at different buildings by date. I'm looking to have the building cell be highlighted if it has had multiple incidents in the last 30 days. Ideally if I can do this with conditional formatting or use a check box formula that feeds into it.
Index / Match with Checkboxes
I am trying to pull into my Team sheet summary as the "Status Phase" the value of "Project Phase" from my Status sheet when the "Final Version" checkbox has been checked. I am using the following formula but it won't read the checkbox value, it doesn't matter if it's checked or unchecked. Can't figure out what I am doing…
Smartsheet Enhancement Request: Snapshot/Print Workflows
I have made several workflows that were fairly large for different applications in smartsheet. I would like to have a simple function to print/pdf the workflows so as to see all of one at once. This would help me with design, troubleshooting, and communicating the process to those involved in it. I have submitted an…
Help Article Resources
Trending in Formulas and Functions