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…
We are running into issues with our faculty getting sidetracked in the middle of responding to an update request and if they try to use the email link again it gives them a message that says the link has already been used or canceled. Is there a way around this or an idea to help us with this?
I get this error when I try to edit or go into a form , formName: ajax formAction: fa_getLicensing serverStatus: false serverStatusText: CriticalException errorCode: 48 we upgraded our account recently how do we correct this issue
Hi all, Question: What makes cell formula update/populate a value and why would there be a long delay? Here's my issue: I noticed a request was stuck in my workflow, and when I reviewed the cell history on the helper columns I noticed the culprit was a cell with a relatively simple formula that didn't populate a result…
Hello everyone, I'm building an automated Above Ceiling Work Permit process for our hospital and have almost everything working. I'm hoping someone can tell me if the final step is possible using native Smartsheet features. My current workflow * A contractor scans a QR code and completes a Smartsheet Form. * The form…
I am using the new "linked" column for a dropdown on my sheet. Is there any way to sort the dropdown options? I have sorted them on my source sheet, however it doesn't update in the dropdown.
Hi everyone, I am looking for advice on the best way to architect a cross-team project tracking system. My current setup: * I have multiple teams, each maintaining their own individual project sheet. * Each sheet contains a list of projects specific to that team. The Goal: * Cross-team Dependencies: I want to add a…
I am building out my sheet summary from a schedule. I have a Parent Row column and all of my parent rows have a checkbox. I want a formula that looks at the first checkbox and looks at the status. If status is Complete, that summary field would then indicate that the Project is in Definition. If the status is In Progress…
I'm trying to create a formula that requires the account# to be 10 digits. I've tried the formulas that I've generated, and they all return an error. This information is tied to a form that requires the account. Help please.
I am trying to create a sheet summary, where the field is a formula that relies on a contact card within a column. However, it keeps returning a result of "#NO MATCH". The columns involved are, 1:) Priority (symbol column) for Up, Unchanged, and Down, and 2:) Contact Card column. I am trying to get a sheet summary formula…