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
Auto popluate a cell based on a check box
I have two columns with check boxes . When one of them is selected I want another column titled Employee Name, to auto populate with the users name who selected either the pass or fail columns.
Formula for Duplicate Entries
This discussion was created from comments split from: Warning message when Duplicate entry is done through form.
Formula Referencing Another Sheet Generating Errors
Hello, I have a sheet that is returning data from a form and I created another sheet for automated reminders if the form update is not returned. Both sheets have column titled "Email" that is a contact list. I'm trying to create a formula that references the form sheet Email column and the Email column in the other sheet.…
Contact Automation - Resource Manager
Hello Community- I am trying to automate contacts into tasks based upon role using a metadata column for a timing plan vs. having to fill out each contact across 50+ milestones.... The problem is we use Smartsheet resource manager and the contact column does not allow formulas to grab the contact from the metadata column…
Identify blank cell output from formula in Date column
I'm having a problem trying to capture a blank value from my Date column. I have 4 date columns: Planned Start Date Planned End Date Actual Start Date Actual End Date My goal is to capture an error message in a [DateError] helper column based on the lack of input in these columns. For example, IF(AND([Planned End Date]@row…
Can I automate sub task numbering
What I'm looking for is to assign ascending numbers to each sub task, starting from 1. Like how I have included in the photos. Update: I found the threat where people are talking about the WBS template. If you're reading this and you have not found it yet, here is the link…
Seniority Order Numbering
I have a union workforce and they rely heavily on seniority for scheduling and mandatory overtime, etc. I've developed a seniority tracker/calculator that keeps track of seniority through status and title changes. I can easily pull reports filtered and grouped by lists (Full Time RN, Part Time RN, etc.) for them to see…
Understanding Smartsheet User Profile Discrepancies: Name vs. Email Address in Workspaces and Sheets
Hi all! I've got an issue with Name and Email Address of a Smartsheet User not "linking" (for want of a better word). Please bear with me as I try to explain the problem! :) A Smartsheet user needs to be shared to a workspace. When I searched their name in order to share it with them, it shows me their name as they've…
Formula to check a parent checkbox when any child is complete & formula to complete a parent status
Hi Smartsheets Community, I need some help with a formula that I am stuck on. Below is a screen shot of grandparent to parent, to child hierarchy. Grandparent is in yellow, parent is in blue, and child is not highlighted. I put I am using the following formula to add a check mark on the parent row when all of the children…
copying data from row above to rows below via column formula
With form 1 in this example we enter account manager, client hit submit, the another form opens to fill in the services performed, so our users don't have to fill in redundant information for each service. Is there anyway to use column formulas to fill in the Updated Account Manager so when we use reports we can filter…
Help Article Resources
Trending in Formulas and Functions