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
help need with multi select lookup: JOIN/COLLECT/HAS?
I am trying to look up the email addresses for employees where multiple employees are in a single cell. I use index matching for single employee names successfully, but am struggling with a multi select. The employee column (Who are you appreciating?) is multi select. The standard index match processes a "#NO MATCH" whenβ¦
Start and End Dates
As you can see from the picture below I have set up my columns to track certain dates. I work in construction so I have typed in what the GC gave me as a schedule. That is the Start and Finish and there duration. What i am trying to figure out is. When Status changes to "In Progress" I would like for it to Record theβ¦
Can you generate a date in a new row based on the row above it?
Trying to automatically generate dates that skip weekends to prompt an update request. Current solution is dropping in all the dates for the year into a date column at once. Any ideas would be greatly appreciated!
New to Smartsheet. trying to figure out a formula
I am trying to figure out a formula that will help me track data. I work in construction so I think this will help me out. Example, I have 100 duration days to complete interior framing. I have gone through the schedule a picked what is interior framing and that will give me a % complete of what is done. Now what I amβ¦
Formula
Hi All We have the following challenge We have a sheet where employees can bid for hardware like: Name - Hardware - Value John - Iphone 6 - 60 Euro Michel - Samsung - 50 Euro Frank - Iphone 6 - 70 Euro Smith - Samsung - 90 Euro In another sheet we want to receive the information who bides to most for the hardware like:β¦
Form Help
I've created a form and introduced logic for several responses. If the field is populated, a follow up question with radio buttons becomes visible, 'A' and 'B'. I want to be able to calculate at the sheet level the total of all questions answered 'A' and also calculate all answers calculated 'B'. I assume an IF statementβ¦
#Invalid Operation - Referencing another sheet
I am having trouble with this error. Pulling data from a sheet with same column names. (dumbing my equation down for simplicity) {Master Daily Job Log Range 1} = Date Column in Master sheet. {Master Daily Job Log Range 2} = Job Overview Column in Master sheet. Equation in my Yesterday's Job Report Sheet =IF({Master Dailyβ¦
Retroactive Workflow Solution
Hi If I create a workflow to copy rows to a new grid, will it work retroactively if the criteria was met before the automation was created? For example if my "approved" column has an "If YES move to new sheet" workflow added tomorrow, would anything that has YES in that column from today also move to that grid? Thanks Dan
Count by date modified
Hi! I would like a COUNT of Number of Task Items (these are multi-select) of the number of "lodging" for the past 7 days but I want to go by the date modified. What am I doing wrong? My formula isn't working: =COUNTM(COLLECT(Task:Task, Modifiedby:Modified by, @cell >= TODAY(-7), Modifiedby:Modifiedby, @cell <= TODAY(),β¦
Sort Question
We use our smartsheet like a "ticketing" system for tasks. Several people all over the organization put in tickets that flow to the worklist set up for the team completing. When the tasks come in we want the list to be sorted by a date field, however, you have to constantly "refresh" to get the items to sort correctly. Isβ¦
Help Article Resources
Trending in Formulas and Functions
Creating a multi-sheet formula to match a contact list that references a drop-down list
Hello to you, Smartsheet community! I am in need of assistance with formulas. I'm so lost in the syntax that I don't know right from wrong, up from down, HAS or COLLECT π΅. I do not identify as a power user with formulas β wizards are my dearest friend β so this push into the advanced features has been a journey. Is itβ¦
Conditional Formatting for Dates
I have two columns, one with a projected date and one with an actual date. I want the actual date to turn red whenever it is later than the projected date. How would I make this happen?
IF formula from Excel to Smartsheet
Hi, I currently have a spreadsheet in Excel I am moving to Smartsheet with an IF formula. Can someone help translate what this formula should be in Smartsheet? In Excel, the Current Widget Liabilities formula is: =IF((2023 Paid Widget Balance + 2024 Paid Widgets - Widgets Created in 2024) <0,0,(2023 Paid Widget Balance +β¦