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
Check Boxes
I want to have one column with Approved checkbox and another column with Rejected checkbox but I only want to be able to select one at a time. Any help would be appreciated.
How to automatically update a date column when a date has changed in another column
I am needing assistance with my smartsheet. I have a column that is a date column and I enter the date a project is "tentatively" going to start. I have another date column that I use to tell me on this date I need to call the client to remind them of their start date of project. Very often the "tentative" start date gets…
Can someone help with following formula - need to extract value
Hi, Hoping someone could assist me with creating a formula that would allow me to get specific value from a field. Our system gives us the Description field which contains data we want to use to further separate our data. I have tried various formulas but I run into issues since the numeric part can be 1 to 3 digits. Only…
Record a date for previous check box
I want to record a date for when the check box is true. I know I can set up and automation but I want to see the dates of previous check box.
Desire blank output instead of #Divide by Zero
Hi, I am using values from different sheet to calculate duration. However, the other sheet does not have values at all time, it may be blank, 0 or output an error. How can output a blank field when my formula comes across such a field. current formula that works fine with fields that DO have values: =AVG(COLLECT({Incident…
IF / AND / OR WORKS ON EXCELL BUT NOT ON SMARTSHEET
Hello Everyone, I have a formula I am working with, that is working just fine on excell but not in smartsheet, it shows #UNPARSEABLE, PLEASE HELP !! HERE IS THE FORMULA :…
Combine Data from 2 sheets using one common column as a link.
I have 2 sheets training of Team Members with their certificates as an attachment (see screenshot) position assignments of Team Members B (see screenshot)oth sheet have email address as a common link already used for formulas reporting if training was completed and training class names. Already have one report of the…
I would like to ask for help with updating status my formula:
I use the below formula to return a status (Upcoming, In progress, Complete, Behind) based on % complete and due date: =IF([% Complete]@row = 0, IF([Start Date]@row < TODAY(), "Behind", "Upcoming"), IF([% Complete]@row = 1, "Complete", IF([End Date]@row < TODAY(), "Behind", "In Progress"))) I would like add another…
Help with Summary report build using matching dates to sum meeting minutes used.
Good morning! I am trying to build a meeting report for my team's weekly Work In Progress (WIP) meeting. I am using a form for team members to fill out how much time they need for our one hour meeting and on which date. I have a formula that takes any matching [WIP Dates] and sums their [Time needed in minutes] The Sum of…
Can I get the SUM of values in a range of cells between a date range?
Greetings all. Would it be possible to count a numerical value in a range of cells based on a window of time (Month)? I want to create a dashboard that captures a participant's monthly total over a year.
Help Article Resources
Trending in Formulas and Functions