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
I want to count how many tickets the Assigned to group Business Systems received in January
I am trying to count the amount of tickets the Business Systems teams received in January. There are other teams in other rows. The formula I tried was: =COUNTIFS([Assigned Team]:[Assigned Team], @cell = "Business Systems"), @cell <= TODAY(), [Assigned Team]:[Assigned Team], @cell > TODAY(-30))
New Comment/Attachment Alerts
Hi all, I created a workflow to send a notification if a new comment or attachment is added to a ticket. We have a ticket "Requestor" and then an "Assigned To" user. I have the workflow alerting the Assigned To user a notification if a new comment/attachment is added to a ticket # (row). Is there a way to filter or edit so…
Adding year to quarterly equation to count
I want to count how many projects in each network have expected completion dates within the quarter per year. For example, in Upstream, I know 3 projects will complete in Q1 2024 but 1 will complete in Q1 2025. The formula I'm using won't account for the year and count correctly for what I know are the actual expected…
New to Smartsheet add number to date in new column.
I have an Approval Date column, and an Approval Cycle column. The approval cycle column is a dropdown of varied numbers. The third column should take the date from Approval Date and add the Approval Cycle number to the year. This is what is in there... =[Approval Date]@row + [Approval Cycle]@row But it's just adding it as…
Trying to calculate a change over time, but ignore missing data
Formula: =IFERROR(ABS([2012]@row - [2023]@row) / MAX([2012]@row:[2023]@row), "") but the formula returns a 100% if the first column data is missing. If the last column data is missing, the % change is skewed lower. The data is not restricted or proprietary. it is new construction cost by zip code over time.
Is there a way to have text repeat all the way down the primary column?
Is there a way to have text repeat all the way down the primary column, even when new rows are added without having to manually enter? I am trying to use this as a helper column so this is what displays in the calendar.
How to display # of request entered by week in Dashboard
Good morning, We have a form used by our team members to enter any issues they are encountering. I have created another Calculation sheet to create my dashboard based from the sheet collecting the data/form. I would like to display in my dashboard how many issues are entered every week and show it in a chart by week. What…
How do I create a report that is a pivot of duplicate items, with a status?
Hello! I have a tracker that consists of multiple contacts per client resulting in duplicate names for a single client, however, a single "status" column that covers the client. I am trying to pivot the client and status however, am struggling to figure this out. I would like to create a report by status that I can then…
Is there a way to auto generate a new row in the same sheet if a criteria is met in a specific cell?
Hi I'm trying to see if there is a way to auto-generate a row in the same sheet based on criteria met in the previous row? To add another layer to the question, is it possible to have the auto-generated row be a copy of a pre-set sample row in the sheet? I'm still new to smartsheet and there may be an even easier way to do…
Need help with a IF
Trying to create a formula where it would originate a % calculation based on a Yes or No from another column. New to this so not sure on how to proceed. This is what I have so far =IF([30C Low income or rural]@row = "Y" , (CAPEX@row * 0.30")]
Help Article Resources
Trending in Formulas and Functions