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 am posting here because our team is facing a critical issue and we've been unable to use our sheets for several days now. We are currently on a Business Plan and have already submitted three official support tickets through the AI assistant , but unfortunately, we haven't been able to reach a Smartsheet engineer or…
Did Smarsheet roll out an update that prevents Editor-Can Share from unhiding and unfreexing columns?
I have the problem that the automation that puts a date in a DATE field, when it passes 6:00 p.m., sets it to the next day. My time zone is GMT-6, but it seems that the automation doesn't respect that setting.
I have a sheet that is setup with a data mesh to pull in data from a sheet someone else is managing. I'm looking to setup a data shuttle so when I pull data from an external source and drop it in my sheet it updates one particular column within my sheet. The only column in my sheet that has a column that matches the…
I have the following three formulas in the same column of my sheet that I reference in a dashboard: =INDEX(Accomplishments:Accomplishments, MATCH("current", [Report Class]:[Report Class], 0)) =INDEX([RYG Overall]:[RYG Overall], MATCH("Current", [Report Class]:[Report Class], 0)) =INDEX([Overall Trending]:[Overall…
I built a sheet to track schedules with several trades with start and end dates for tasks. I created an automation that would check a box in column "Needs Confirmed with Trade" if I changed the start or end date and the mentioned checkbox is unchecked. Then I have conditional formatting highlight the row if this is checked…
This is not a formula syntax problem. Our formulas are unchanged and correct. Smartsheet simply can no longer resolve references to other objects in our account. Since Aug 13, every cross-sheet reference across the entire account returns #REF / #INVALID REF / #BLOCKED. Formulas inside a single sheet still work fine. It is…
I have automated functions within a time off work request sheet. The problem I have is whenever I change the approval status (drop down list), regardless of what it is, the sheet reverts back to "submitted", which messes up the authorisation process. What is very odd is there is NO automated setting to make the cell change…
Hi All, I have a bit of a different ask than what I saw already listed here. 1. I need to subtract a certain number of hours from a military time format and add it to a third column. Please let me know if you can assist. Thank you!