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.

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Get the DisplayValue of a Hyperlink
I have a column of currency values that are hyperlinks to receipts. I want to total the column but the SUM function does not recognize the displayvalue (the currency amount). How do I Get the DisplayValue of a Hyperlink? Thank you in advance
Triggering an automation from an attachment revision
Hi - I am trying to trigger an automation when I upload a revision to an attachment. I already have the document generated by changing a field and then when I upload the revision, I want the same field to change again. For some reason, I can't seem to trigger from the revision. I tried setting the trigger to a new…
Subtraction formula with conditional IF statement from cells populated from index match
Hi everyone, I'm trying to create an inventory spreadsheet that auto calculates the QTY in the warehouse by subtracting the amount received from the amount signed out. These columns are populated via an index match formula cross referencing another sheet. I also need there to be the caveat that if nothing has been signed…
Automation for creating a Template of new child rows when a Parent is copied from another sheet?
I'm working on creating some workflows that will copy information from a change order tracker sheet into a resource assignment tracker sheet. Ideally, I'ld like to grab key details from the change order tracker (number & name) over to a resource assignment tracker, then have additoinal rows added on the resource assignment…
Sheet Title Formula?
Does anyone know if there's automation or a Formula where I can pull the Sheet Title into? For example, I want to create a "Project Name" column in a template that will bring the Sheet Title down to the row level. The use case is to then have a dashboard/report that will combine all my project sheet tasks into one. I know…
What would be the formula to only count parent row items with the "in progress" statuses
Hello Everyone, I am new to Smartsheet and I am struggling with identifying a Smartsheet formula for one of my sheet. I am attaching an example image for reference. Here, I have three columns with headings "Only Projects", "Project Name", "Status". I would like my "Only Projects" column to display the value "True" against…
Form Submissions causing duplicate names on sheet
hi there! my department is sending out forms to various departments, and when they fill in the form and submit it, it adds the entry to the bottom of the sheet. my problem is I already have the names listed on the sheet, so their names are being added twice. is there a way to delete the name that is blank above once the…
IF formula to return date based on drop down selection
I have a formula that is working correctly returning a date based on a drop down selection. Now I need to incorporate business days into that return date instead of total day. I have 3 columns i'm working with, Priority, Requested date and Request due. The user will enter the date the request is received and select the…
How can I get the column to accurately track hours elapsed?
Hello! Trying to have Total Time calculate total hours elapsed from Start Time to End Time. I created "helper" columns based on another question's answer, but it didn't help. We use 24-hour clock here and I need the column formula to consider that some values will start before midnight and end after midnight and will…
Countifs f-la
Hello, to this formula how would i add another sheet to get the match from? this formula says: match employee name, and if the column (sheet 1) has this document title return green, if it doesn't return red (sheet 2). Now i would like it to do the same thing but from a different sheet and return to the same sheet?…

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Popular Tags

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Can anyone tell me what's wrong with my formula?
I'm trying to set up a project plan that has color indicators for the timeline: RED=past due, Yellow=due in the next 5 days, Green=due in the next 14 days, Blue=due later. =IF([Due Date]2 < TODAY(), "Red", IF(AND([Due Date]2 >= TODAY(), [Due Date]2 < TODAY(+5))), "Yellow", IF(AND([Due Date]2 >= TODAY(), [Due Date]2 <…
Help with a #UNPARSEABLE error
I want to reference the values in a column from another sheet (2025 IOE Procedure Assessments Equipment). And if any of them match any cell from the Equipment column from the sheet I'm working in then, I want the Audit on Equipment Completed column to return a "Completed" value. This is my formula. What is wrong with it?…
I have the Year and Month on a sheet. How can I have the summary look at both to count?
I would like to create a summary if the month is Sept AND the year is 2024 to count. I have found that I can use the and but keep getting an error message This is the Formula I have in the Summary that is coming up #Unparseable =COUNTIFS([Next Renewal Year]:[Next Renewal Year], "2024") AND(([Next Renewal Month]], "Sept")

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags