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
Sign in and
ask it here! The community's got your back.
📈
Wondering if there’s a problem?
Check out the
Status Page and subscribe for notifications.
💡
Share your knowledge!
Help others by
answering questions.
Discussion List
Checkbox, Texts, RYG
I am trying to create a formula based on checkbox and dropdown list column. The result I am looking for is for Column 3 to have either a Red or Green symbol based on if Column 1 is checked OR Column 2 includes a specific word. Column 2 is a drop down with multiple options. Is this possible?
Is there any formula to capture the current/real time in smartsheets?
Hi there, I want to set up an automation on a sheet where, if a form is submitted/received, within an exact 48-hour time frame I can trigger the mail. From created date column, I can get the time on when the row is created. But I'm not sure about how to accurately track the passage of 48 hours in order to send the email…
Trying to combine 2 AND functions with an OR
Hi There! I am new to SmartSheets and am working on a way to automate a process using the OR with AND's and running into trouble. Basically, I am trying to check a box in a column if any of the following is true. If the Model type is 1 AND the version is less than 9 OR If the model is 2 AND the version is less that 18…
Formula for unique job number
Is there a formula I can use to create a unique job number where the prefix is the last two numbers of the year created (i.e. 23-0001 for 2023 and 24-0001 for when it is 2024)? If preferable, can this be done in a formula rather than needing a column for the date created, auto number etc etc. Thanks!
#invalid value on formula
please help me; this formula is returning an "invalid value. The column is a Date =IF([Date of Last Invoice]@row < DATE(YEAR(TODAY()) - 2, MONTH(TODAY()) + 6, DAY(TODAY())), "Inactive", "Active")
Recurring tasks that need their due date to update regularly
Hello! I am creating a sheet to manage our facility life safety inspections. Some of them occur monthly, some occur weekly, others semi annually and others annually or more. What I am hoping to do is create a formula that will update the due date to the next date, after the current inspection has been completed. I plan to…
Invalid Value ERROR
This discussion was created from comments split from: Newbie: trying to return cell contents if date is less than and greater than....
Question regarding equation output if cell value is negative
Hello all. In a budget tracking sheet I created, I have a row titled "Remaining" that subtracts monthly input spending from the original "Bid" column. In the case that a value in the "Remaining" column is negative (over budget) I would like this number to be subtracted from a contingency row I have in my bid column where…
SUM
In sheet summary, how do I sum up a column?
Pending Update Request Icon in Sheets
Good Morning, I have a sheet that has automations for update requests when certain criteria is met. On one of my sheets it has an icon for one of the rows indicating there is an update request, however, the update request has been completed. Anyone know why it would still be there? Thank you, Cara
Help Article Resources
