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
Add a Formula to a Cell Using Automations
Is it possible to add a formula to a cell using an automation? I attempted to do this using the Change cell value action, but it only adds the formula as text. The sheet does not recognize it as a formula even though I did start it with an "=". I'm trying to populate the value of a cell with data from a cell in the same…
Calculating Time difference between Auto Generated Date/Time and Manually Entered Time column
Hello, I currently have a form that collects a small sample of data and then generates a row on a sheet, and that row has a "created" column using the auto generated date/time stamp. Someone completes that task and then marks the row "Approved" which generates an approval DATE and then they manually enter a time stamp…
Count total
Hi I wish to calculate the total number of hours for a specific region from my list. so for example I wish to look at column "Region" find all Europe and then count the number of Hours from the "Total Number of Hours" column for all Europe I tried the below but it only counts the number of times Europe was chosen and not…
Auto Generate sequential # to different Project ID category
Hi there, I am looking for a formula or a solution to auto generate Project ID with sequential # once Project Type was chosen in Intake Form. I described what I would like to achieve in detail in an attached document. Could you kindly take a look at it and let me know if this is something SmartSheet can handle? Best…
How to capture time elements from a form and display on a dashboard.
Good morning Experts, I have a particular set of data that is tracking productivity with a time element reported as (hour):(minutes) AM or PM I am gathering the data in a form using text/number. Once in the sheet/grid I cannot figure out If I can or how to auto populate the results for a single time element in my sheet…
invalid operation
Hi Experts, I got the error invalid operation, but I could not find the mistake in my formula. Would be great if somebody could help? Thanks
Consistent [Column Name] Formula
Hi, Is there a way to add like a string "[Column Name]" so whenever I add a new column that has that name the formula stays refrenced to that new column with the same name? Thank you!
Using workflow, is there a way to automate the email notification w/o manual adding the recipient?
I'm using the automated workflow for one of my trackers, that when it's approved, it will alert someone as an automated email to the requestor, however since the details are from my Smartsheet Form intake, I will have to manually input the requestor's email or their Smartsheet user name to the selected column for it to…
How can I count distinct values under a same month?
Hi everyone, I currently have a data set for which I would like to count all unique values that are under a same month and a same year. For example, the following table shows two duplicate values (TR ID's) on two different dates. In this case I would only like to count the unique TR ID's for the month of August, 2020…
Excluding two values for Sheet Summary Formula
Hi all, I was wondering whether you might be able to help. I have a column "Status" and I would like to write a formula for a sheet summary field that counts the number of status' that are anything other than "On Hold" and "Complete". I've tried various COUNTIFs but none seem to be working! Any help on this would be great!…
Help Article Resources
Trending in Formulas and Functions