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
Fonction Date + Counif
Hello everyone, I am looking for a formula allowing me to return the projects in progress during the month. In my logic the formula gives this: IF(AND({2022 Plage 1}@row >=[Colonne5]2; {2022 Plage 1} <= [Colonne5]3); COUNTIF({2022 Plage 2}; [Colonne principale]@row); "") With : [Colonne5]2 =DATE(YEAR(TODAY());…
Network Days where same day = 0
I want to know the number of working days between two dates but when the two dates are the same day I would expect it to report 0 but instead its reporting 1. For my purposes items done same day would be a 0. Items completed a day later would be 1 day and so on.
Can't add days to a Date
Hi, It seems like I cannot add days to a date by a formula. Formula is below: =[CX Finish Date (F)]@row + 2 And see the Screen shot below, above formula adds the number "2" to the end of the date as a text. However, it is expected to have 2 days added up to the date that was selected. Thank you in advance.
How can I record "old answers?
Hello, I was wondering if there was a way to record old/initial updates to a cell. I am trying to record the most recent Z# to the most recent cage cart update. The problem exists when the same cage cart is spotted with a defect. The sheet on the left contains the carts that we have found to have a defect with the…
#INVALID VALUE error with collect/index/match/small function
Hi all, Feeling like I've got a real head scratcher here- I have been struggling with this formula creation for the past few days and am hoping that the gurus can help! Within my sheet, I have UniquePart pulling in a list of unique values from a source sheet. The frequency of the part within the source sheet is then…
Summary Report
I am trying to create a report that summarizes my Mods per week. I tried putting a Summary in the sheet and then creating a report with this data. Problem I would have to create a summary for each week (52). Then I would like to have the same with the Item totals per week. I did create a column with week totals for Mod and…
COUNTIFS incorrect argument set
Hello, I am looking to gather metrics from a sheet of QC submissions. I have a very limited understanding of formulas but have managed to put together something that works through looking at examples on here and the tutorials. I have had success with the following formula counting the number of submissions of a certain…
Formula needed to return value
Hello! We are a small nonprofit and are trying to build a Smartsheet that allows volunteers to sign in, choose which outreach (activity) they do, and then based on their outreach choice, the formula would automatically assign a number of hours for that outreach (so that we can track volunteers number of hours worked.) I am…
Change value of child based on parent
In this sheet I'm monitoring the inventory of raw materials. Currently, each child row compares available stock to low stock amount and returns OK or "low". However, the parent includes the total of all batches of the raw material, so that even if one batch is low, the quantity of the raw material might be sufficient. So,…
Can I automate a cell to change color?
I have a column called "Due Date" that I want to turn red when 4 weeks from the due date have past. Is there way to change either the cell color or text color?
Help Article Resources
Trending in Formulas and Functions
Formula needed to count occurrence of a field value across multiple sheets
Scenario: Sheet A contains a field : Value Proposition. There are 8 rows in Sheet A. VP1 VP2 VP3 etc Sheet B and Sheet C have long lists of tasks, each task is assigned a Value Proposition (in field Value Proposition) In Sheet D (which is a Metrics Sheet) I need a formula to count the number of times that a Value…
I'm receiving an unparseable error with this formula? What do I need to adjust here?
=IF({VPAL Portfolio Status Range 2} = "CoaP" + {VPAL Portfolio Status Range 1} = "3. Moving Along", "Green", "" ({VPAL Portfolio Status Range 2} = "CoaP" + {VPAL Portfolio Status Range 1} = "2. Needs Monitoring", "Orange", "" ({VPAL Portfolio Status Range 2} = "CoaP" + {VPAL Portfolio Status Range 1} = "1. Needs…
SUMIFS with sheet reference
I've read multiple posts and articles but something just isn't work in my SUMIFS formula. I'm trying to add the number in the Social Posts ({SPosts}) column if the Type ({Type}) is "Social" and the Team ({Team}) matches the name in my summary sheet column (Label@row). Any help would be greatly appreciated.