Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
Sign in to ask your formula question or join a discussion.
Check out a list of all the available functions in Smartsheet.
Download the Formula Handbook with 100+ formulas and in-sheet examples.
An article with frequently used functions and additional resources.
Hi Community, Whether you’re summing child rows, calculating budget minus actual, or doing cross-sheet data lookups with multiple criteria, formulas are a must for tailoring solutions to your needs. The new Formula Handbook is here to help formula beginners and pros alike. This template contains: A glossary of all…
I have a sheet for travel requests and will be creating a new line for each travel request. I need to create a one page document to send to a customer that includes all this information neatly presented for each row "travel request" with all the columns in the attached snapshot. How can I set this up?
I generated this document from a row on a sheet. How do I update it to be portrait instead of landscape. And how do I delete the blue lines in the middle? I need it to be presentable for the customer.
We are getting duplicate notifications from our automations. These automations have been in place for over three years and have never done this before. There have been no changes made to any of them. This is happening on a variety of sheets and a variety of automations. It started sometime about mid August. Is anyone else…
Hello Team, I need to write a logic between 2 rows. The formula should be based on the previous row status. How can we achieve this in the Smartsheet ? Here is the example. 2 teams involved. Developer and Approver. The Approver Status need to be changed based on the previous team task status. For both team, we have a…
I am trying to extract information from the main sheet and create a report that calls out Garment Type in the date range of our FY.
Is there a way to set up an automation to show 10 working days (Mon-Fri) before a certain date?
I have a sheet designed to assign submitted form information for review on a rotating basis between 3 people. That’s all working fine. The issue I’m having is that if a form is resubmitted for secondary review, I need it to assign to the original person and not fall into the rotation. So find any duplicates in a column…
I have been using the new Table instead of grid , I created a Dynamic View and I have noticed that it has lost all the formatting, whereas, when I have created a Dynamic View from Grid, the formatting remains.
Hi good afternoon, Community Members, I need some help please. I have an issue with my Health Formula. Here are some of the concerns: I have Red tasks, but they do not affect the timeline. Actual completion is ahead of Expected %, but Health is Red. An activity is Yellow when it should be Green. One delayed task makes the…