-
NEW! Your survival guide to formulas is here. Meet the Formula Handbook.
Hi Community, Whether you’re summing child rows, calculating budget minus actual, or doing cross-sheet data lookups with multiple criteria, formulas are a must for tailoring solutions to your needs. The new Formula Handbook is here to help formula beginners and pros alike. This template contains: A glossary of all…
-
Formulas
If you have different numbers per line in the barcode column, you can see which product it actually is from these numbers. For example, 9040005530102: from the first two digits, you know that this product is DIM90. In the same barcode column, after scanning, you may also see other numbers such as 10040005590117, which is…
-
Using a form to collect data on a sheet specific to a row
Context: We have sheet with a list of dates and meeting types as parent rows and then the agenda for each meeting as children rows underneath. In each row with an agenda topic, there is a cell that shows the presenter. We would like to collect details on who is presenting from non-editor users. I created a form that allows…
-
Stacking updates
Hi, is it possible to stack updates in Smartsheet? We add new lines via input form, but the lines will be regularly reviewed via input form as well and this way new updates will be added. We would like to keep all these update comments stacked in one cell. Is this possible?
-
Counting Specific Items within an array where row meets criteria
Hello, I am trying to count specific text within and array: Basically, I am trying to count the number of times Testing occurred in the last 2 weeks, so using either a specific date or the check box. I will also expand this to specific people that is not shown in the screen shot. I have the formula to count the array, but…
-
Countifs + contains with reference form another sheet
Trying to reference another sheet with the COUNTIFS + CONTAINS formula and am getting this #INCORRECT ARGUMENT SET Here is the formula I am using =COUNTIFS({ReturnOrder}, Date@row , CONTAINS("STS", {Companyname}))
-
Is anyone else struggling with duplicate assignments (i.e. Assigned To field)?
Hello! We recently moved a manual task assignment process to Smartsheet. The issue we're experiencing now is duplicate assignments. 10-12 team members are accessing the sheet at any given time. Changes are happening all the time. And while they are refreshing and saving consistently, team members are stepping on each…
-
Adding a secondary sheet into the equation
HI! I have the below formula which is pulling info from a sheet and giving me a percentage based on the p/f in a column. I have a third sheet that is the same info as the p/f sheet this is based on (technically the archive of this one) that i would like to add in as included in the percentage. So basically my formula needs…
-
Rolling View - Timebound
Hi community! I'm trying to figure out a way where a report will filter and pull based on a time frame. I have a sheet where all of our cyclical events are listed with start/end dates. I want to provide a way where only current events (in progress today) and going through next 3 months are pulled. Suggestions on how to…
-
Pull most recent date from another sheet based on two criteria
I am trying to pull the most recent date that a recurring job. I have the facility where the work was conducted, the last day of the job and the job category on the other sheet. I need the category section of the formula to look for a word contained within the text.
-
% of check boxes
I am trying to make the row 20 box thats selected to display a % of the check boxes in rows 2-19 that are selected. I have tried a couple formulas none work. =COUNTIF([Complete]2:[Complete]19, 1) / COUNT([Complete]2:[Complete]19) =COUNTIF([Complete]2:[Complete]19, "true") / COUNT([Complete]2:[Complete]19)