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.

SUMIF, NOT Function, excluding specific text in return
Hi All, Hoping someone may be able to help with the final section of the below formula. it works as it should up unit the last bit. Aim of the formula: Sum of "ScheduleValue" if: ScheduleWCDeliveryDate is more than 01/12/2020 (Works) ScheduleWCDeliveryDate is less than 30/12/2020 (Works) ScheduledDespatchDate is Blank…
Is there a function that will change the Health RYG Balls color?
Is there a function that will change the Health RYG Balls color if a specific criteria is met. Such as Budget, due date or other?
Column formulas
I need to subtract two days from an end date@ row and exclude weekends and holidays. Can I use this formula and incorporate the -2 days somehow? NETWORKDAYS(start_date, end_date, [holidays]) Thanks,
Issue with formula in sheet summary
Hi, I am having an issue with my formula: =COUNTIFS([Start Date]:[Start Date], IFERROR(MONTH(@cell), 0) >= 7, Type:Type, OR(@cell = "Residence Life Event", @cell = "6 in first 6", @cell = "Welcome Back Event", [P.A.W.S (Res Life Only)]:[P.A.W.S (Res Life Only)], "Philanthropic")) I want it to count events that are equal to…
Project Plan - Settings, Turning off/on rows per selections
Hello All, Looking to see if there is a setting/function to turn off/on specific rows or tasks in a project plan based on selections. I work with large plans for market launch. Depending on the market type, there may be deliverables that are needed or not needed. Example - Can I select a project sponsor or market type in…
Populate cells based on the different select of a multiselect column
Hello, I'm not sure how to handle this one and your help will be much appreciated. I have one MultiSelect column with a number of Main Countries (coming via a link from another sheet). For each country present in the Multiselect, I'd like to populate one cell with the country name. I just have no idea how to do this. Can…
Returning date either 15th or 31st of the month
Do we have a formula for rounding off dates to either 15 th of the month or 31st of the month? for example if the date falls between 1-15 of a month, I need 15th as the date for that month and year. and if a date falls in between 16-31 then it should return 31st of the month and year. Kindly advise. thanks for your help.
Military Time Calculation: Night Shift
I have columns set up in 4-digit military time. The formula below calculates day shift (0800 to 1700), but returns a negative value when calculating night shift (2200 to 0600). How can this be resolved? =((VALUE(LEFT([End Time 1]@row, 2)) + VALUE(RIGHT([End Time 1]@row, 2)) / 60) - (VALUE(LEFT([Start Time 1]@row, 2)) +…
COUNTIF Formula Help
I'm not sure if I'm making this more complicated than I need to... I'm trying to build a COUNTIF formula that accounts for 2 unique values in User Satisfaction column and can have anywhere from 4 -17 unique values in Team Name. =COUNTIFS({User Satisfaction}, "4. Very Satisfied", {Month Survey Sent}, [Column3]@row, {Year…
Multiple If statements
I am struggling with a multiple if statement....I need to have 8 total. Below is just a start with two. They each work individually (in separate cells) but when I put them together I receive the UNPARSEABLE error. Anyone that can help me get this to work? =IF(OR([Place in Funnel]2 = "Universe", [Place in Funnel]2 =…

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