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
I am trying to count the dates that occurred within the past 10 days
I am struggling in counting the dates (under a date column) that occured within the past ten days. It is coming out as unparseable. I used the formula below: =countif ([date]:[date], <=(TODAY()-7) I would appreciate the help.
Need Help with Formula Creation
Hi, I am creating a metrics sheet for dashboard data. I need to create a formula that is using a reference sheet across two columns. One column in the source sheet is a name, but the second column is time. I want to do a (if name equals, then sum time for the name) formula. If I wanted to put the formula is my source data…
Match Function
Hello, I noticed that the MATCH fomula has a limitation of the length of the text. I.e, I am matching the names between two sheets. I have some long names -Mohammad Ali Hussaini, Mohammad Muttaqi. When i plug in the fomula, it always return the first one. How can i fix this?
Counting user login between 30-89 days
The data set tracks each time a user logs in. I need metrics on users who have logged in between 30-89 days, but I only need to count the most recent instance. Also, I am using data shuttle to bring it in, so I'd like to filter out the duplicate emails keeping only the most recent instance.
Graph - Vertical Axis doesn't have the correct format
Hi Team, Can you please help find the Root cause. I have the below 2 graphs populated from the same base sheet wherein one of the graphs show the Vertical axis with $ values on scale and the other does not. Can you help why the difference.
INVALID VALUE SUMIF Formula
I am trying to add the same base equation to a counterparts sheet which is almost identical to mine, but has slightly different column names. We are trying to create a "Biweekly Sum" column that sums the "Grand Total" / "Talent Paid" linking "Vendor Name or Slack Name" / "Pet Parent CP Name" or "Supplier Number" / "Vendor…
Help with alternative formula to SUM(CHILDREN) for budgets
I've created a budget template that uses the standard SUM(CHILDREN) formula to add the individual dollar amounts for a specific portion of the budget and obviously gives me a total SUM above the individual dollar amounts (purple cell on left). The intended recipient wants to see the total SUM below the individual lines,…
Date formula
Hi. I'm not sure how to go about this. I have a list that have SO Dates that are all different including the year. I plan is to send an automated reminder every 3 months from the SO DATE starting now. For example, I have an SO date of 08/06/23. Based on this, a reminder would have gone out on 11/6/2023 (which is the past).…
Can I register blank cells during a nested IF conditional?
Hi, I have a question regarding a nested IF conditional that counts the next Friday after a date. What I'm attempting to do is to leave the cell blank if the captured date is blank. CONTEXT: My form has a column for manual input ([Actual Date of Publishing]) that I translate into the Friday following that date ([End of…
Vlookup table array with strings
Trying to do get value from another sheet that contains commas and spaces but the Index formula does not work, do you have any other suggestion?
Help Article Resources
Trending in Formulas and Functions