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
How do I create a formula to show how many weeks/days out a task needs to be completed?
For example, if I have an event, or a project live date, and I want a task list that says Task 1 is due 8 weeks prior Task 2 is due 3 weeks prior etc...I am new to this and cannot figure out the formula!
Is Smartsheet experiencing issues with dependencies functionality?
I am currently experiencing issues with dependency functionality. This seems to have started 11/3/22. The functions FS and FF are not working. When FS and FF are leveraged, they extend the dates duration to 2 days vs the 1day duration preset. Are other users experiencing similar issues? Is there an expected resolution on…
Countif not containing specific text
I am trying to create a formula to count "Red" based on one column but not include certain ones which contain the text "Spring" in another column but I can't get it to work. Originally I tried this formula: =COUNTIFS([Aging]:[Aging], "Red", Project:Project, <> "Spring") However, I realized that won't work because the…
Trigger workflow based on time of day a request is received
Hello Community! I have a question I wanted to bring to the table... I've been working on some processes and workflows for triaging work on my team. Requests come in through an intake form and we have automations to assign to specific resources based on the type of project/request that it is. Now, we are trying to make…
PM's - How can I take a date from one cell (which gets deleted) and make it the value of another cel
We're creating our Preventative Maintenance system in Smartsheet and need the "completed date" value to become the "last service date" value. Key factors: 1) the "completed date" needs to be removed in order for the automations and reports to run properly. 2) the "next service date" is "last service date" + "PM frequency"…
Creating Calculated Column in Report (Formula Column)
Dear Smart Community, I looking for the calculating column in the report instead of creating new column in the Source file. I have 7 level of approval and want to know the approval period in this case I have to create 7 new column in the source file instead of this is there any option to create calculated column in the…
Using a Form to input a row into a grid
I created a Form to enter a new row of data into a grid type sheet. The form setup was straightforward and worked fine except when it input the new row into the grid, it left a blank line between the last row and the new row created by the form. I tried it again and this time it left several blank lines between the bottom…
is there an easier way to format a cell to read blank if value is 0?
i have a large report with many countifs to calculated data over time. I want to change it so that instead of displaying the 0 when the formula calculates a 0 the cell is just left blank. I've been using If statements but the formula is so long i wonder if there is an easier way. for example I might use…
Count the number of transactions which are cumulatively equal to or greater than $0?
I have a column of unique transaction IDs. These transactions sometimes are reprocessed. I only want to count the transactions which netted positively. For example, transaction A is processed and shows up but then it is returned whereby it shows up again as a negative. I do not want to count that as a transaction. However,…
How to get list of assets to PDF from one cell
Good day I get the list of assets using this awesome CHAR (10) thing =JOIN([Asset name]15:[Asset name]17; CHAR(10)) Now i want to get thw list of assets to my PDF using some control of where it should be ( like 2 3 4 row ).. And how to put QTY, HOURS and AMOUNT to each cell in PDF?
Help Article Resources
Trending in Formulas and Functions
