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
Checkbox if 2 Criteria Met from Different Sheet
I want to reference a sheet and look for a certain person in the Analyst column and look for a certain status in the Status column. If both conditions are met, I want the sheet with the reference formula to check a box. This is erroring out: =IFERROR(IF(AND(INDEX({Analyst Support Request - Analyst}, ="Paul Smith",…
Is there a way to count the number of attachments in a row?
Hi there, I wonder if there is a way to count with a formula the number of attachments in every row. To give more context, I have created a form to submit excel documents every day by my team, so every entry/row may have more than 1 attachment and I'm trying to measure their productivity and progress every day. I also have…
TextJoin
Hello - Is there any function(s) within SmartSheet that mimic excel's textjoin function? This seems to be exactly what I need but I can't seem to figure out how to do it within Smartsheet. It merges all of the data needed based on if column n matches any & all items in column A.
Return "Invoiced Amt" when "PO Number" matches PO number in multiple columns
Hi there, Relatively new to SS here. I am trying to return the invoiced amount from sheet 1 when the PO number in sheet 1 matches the PO number in column 1, 2, and 3 in sheet 2. I am currently using this formula =SUMIF({PO Number}, [PO Number 2024]@row, {Invoiced Amt}) but now the criterion needs to be from 3 columns, not…
IF formula is not working as expected
I'm sure I'm doing something wrong with this formula, but I can't figure out :( Any help is much appreciated!! I'm trying to add a text to the column "Dispute", so if the # of days in the "Days from Audit" column is equal or higher to 10 text will be "Dispute not applicable" or if the # of days in the "Days from Audit"…
Rolling number
Hi all, I am trying make a helper column (in my calendar I have made) that will give me a number so I can assign that number to a person and they will be on duty when their number comes up. I am using parent rows so I have a level column and I only want this number to appear on the level 1 rows. I need the numbers to go up…
Autopopulate tasks that have not been completed for next day objective
I would like to know how tasks assigned to a person, but have not been completed and thus assigned a "red" status may autopopulate to a new field/cell for the following day so that I would no longer need to copy and paste the same task.
Week over Week (or MoM) Automated Results
Hello Smart Heads! I hope you are doing great! This time I have a question about semi-automated WoW (week-over-week) calculation for specific performance metrics. Thats how it looks as for now: In WoW for SLA I have: =IFERROR(([W03]@row - [W02]@row) * 10000, "") below I have also formula for % change: =IFERROR(([W03]@row -…
Formula Question
I need to create a count formula that counts an item from a multi-dropdown column in another sheet. Not related to a string of information. Can anyone help? Thanks.
How to Create a Chart Line from Multiple Years Data
I'm trying to create chart line in Smartsheet that shows the total cost for the last 6 months which includes August through December of 2023. How can I format my data so the information I'm trying to select can be reflected in my chart without getting an error message like the one show on my screenshot? ( Please select a…
Help Article Resources
Trending in Formulas and Functions