Formulas and Functions

Help with Index/Match formula

steve50951 29 views 17 comments 0 points Most recent by steve50951 03/25/20

First post 03/23/20,Last post 03/25/20
I have a checkbox column "Inv 3rd Party Vendor." I am needing to index a master sheet with all of our property names, and look to see if the "inv 3rd party Vendor" box is checked in that sheet. If it is, I need it to ch…
Formulas and Functions2917
steve50951
Can smartsheet report who checked a checkboxAnswered Question

Answered Tomas Giele 13 views 1 comment 0 points Most recent by Paul Newcome 03/25/20

First post 03/25/20,Last post 03/25/20
Dear Mr/ Ms, I'm looking for ways to organize document control in Smartsheet through check boxes if/when documents are revised by colleagues. I'm looking for a way to 'check' a box, and then in another collumn(s) report who checked the bo…
Formulas and Functions131
Tomas Giele
Nested if for FLAG columnAccepted Answer

Accepted Answer Daniel Child 23 views 2 comments 0 points Most recent by Andrée Starå 03/25/20

First post 03/24/20,Last post 03/25/20
I am trying to build a nested if for a flag column and cannot get my brain around the final piece of the statement. Basically I am trying to create a function that looks at a 3 variables: (1) Date column and if it is not blank and (2)the …
Formulas and Functions232
Daniel Child
Can I default cell values to a formula in the form without getting a ' in front?Accepted Answer

Accepted Answer SuzanneH 39 views 10 comments 0 points Most recent by Andrée Starå 03/25/20

First post 12/30/19,Last post 03/25/20
I have a form entry sheet where I have some columns hidden but defaulting to a formula. The goal is to have the columns populate with the results of the formulas without any updates required (like cutting and pasting the formula in the gr…
Formulas and Functions3910
SuzanneH
Seemingly simple formula will not workAnswered Question

Answered siouxzie7 34 views 4 comments 0 points Most recent by Andrée Starå 03/25/20

First post 02/12/20,Last post 03/25/20
I have a parent cell that should be looking at its children for a value, and if it finds that value in any of the children, it should display that value in itself, else nothing. This seems pretty straight forward, but it's not working. It …
Formulas and Functions344
siouxzie7
Allow updates on demand rather than using weekly automationAnswered Question

Answered Shawn Borror 15 views 3 comments 0 points Most recent by Andrée Starå 03/25/20

First post 02/11/20,Last post 03/25/20
Is there an ability to allow not SS users the ability to update their assigned data elements on demand or does it have to be done via a workflow that runs on time based? Many legal team members need to update on demand for legal 'tickets'…
Formulas and Functions153
Shawn Borror
Based on location, convert survey responses to a numerical value in separate sheetAnswered Question

Answered Amy Arnold 35 views 7 comments 0 points Most recent by Andrée Starå 03/25/20

First post 03/21/20,Last post 03/25/20
Hi, I created a form to collect survey results, the responses are returned to Smartsheet #1 (image below). The survey has 18 questions with these dropdown (single select) responses: Good Satisfactory Does Not Meet Standards Not applicable…
Formulas and Functions357
Amy Arnold
Sum Column results when filteredAccepted Answer

Accepted Answer Mitchell Moses 11 views 1 comment 0 points Most recent by Andrée Starå 03/25/20

First post 03/25/20,Last post 03/25/20
I want to sum numbers in a column of all the vendors. If I filter out certain vendors I want the sum to be only of the vendors showing. How do I do that?
Formulas and Functions111
Mitchell Moses
CountIF but not blanksAccepted Answer

Accepted Answer AJ King 25 views 5 comments 0 points Most recent by Paul Newcome 03/24/20

First post 03/19/20,Last post 03/24/20
Hi everyone - sorry if this has already been asked and answered. But, i am trying to have a box checked if there is a duplicate entry. This is the formula i am using: =IF(COUNTIF([FA Peoplesoft ID]:[FA Peoplesoft ID], [FA Peoplesoft ID]@r…
Formulas and Functions255
AJ King
Trying to find value textAnswered Question

Answered Shirley Vue 10 views 5 comments 0 points Most recent by Paul Newcome 03/24/20

First post 03/24/20,Last post 03/24/20
I'm generating a chart by creating a metics grid for a tracking sheet. I tried using this formula and it's giving me the response, "UNPARSEABLE." This is what I used, "=VLOOKUP( {Tracking Sheet Range 2}"Q1_2020" @c…
Formulas and Functions105
Shirley Vue
Nested IF Formula for Automating Related ColumnsAnswered Question

Answered Danielle Arteaga 13 views 4 comments 0 points Most recent by Danielle Arteaga 03/24/20

First post 03/24/20,Last post 03/24/20
I have a sheet that has rows added through an automated background process (not a form). As the rows come in, they are assigned a date in a column called "Date of Inquiry." There are two other pertinent columns in the sheet: a H…
Formulas and Functions134
Danielle Arteaga
Need FormulaAccepted Answer

Accepted Answer Jeremy Klingensmith 23 views 5 comments 0 points Most recent by Paul Newcome 03/24/20

First post 03/23/20,Last post 03/24/20
I need a formula that will raise the flag when the following conditions are met: -If Status reads "Not Started" or "Complete" AND -If Start Date is less than TODAY
Formulas and Functions235
Jeremy Klingensmith
Helper columns vs #UNPARSEABLE errorAccepted Answer

Accepted Answer Stephen Wood 16 views 4 comments 0 points Most recent by Stephen Wood 03/24/20

First post 03/24/20,Last post 03/24/20
This works for me using helper columns where I do count(parent) and count(children) =IF(OR(children18 = 0, Parent18 > 0), 1, 0) If I substitute the count(children) its #UNPARSEABLE =IF(OR(count(children) = 0, Parent18 > 0), 1, 0)
Formulas and Functions164
Stephen Wood
Time-tracker formulaAnswered Question

Answered Chichi 25 views 6 comments 0 points Most recent by Paul Newcome 03/24/20

First post 03/24/20,Last post 03/24/20
Hello, I have a time-tracker and have 2 problems: For some reason the total isn't calculating. It just calculate 1 hour. Here's the fomular i'm using =VLOOKUP([Talent/Materials]1, $Rate$5:$[Talent/Materials]$11, 2, false) * Hours1 When I …
Formulas and Functions256
Chichi
Send Update RequestsAnswered Question

Answered Chichi 11 views 6 comments 0 points Most recent by Chichi 03/24/20

First post 03/24/20,Last post 03/24/20
I deleted an automated "Send Update Requests" that I set up but for some reason it is still sending notifications to people. How can I undo that even tho I can't see where its coming from
Formulas and Functions116
Chichi
How do I set up a 'running date column'?Answered Question

Answered Tiffany Sherrane 11 views 1 comment 0 points Most recent by Paul Newcome 03/24/20

First post 03/24/20,Last post 03/24/20
Similarly to a running total, I am needing to have a running date. So that every day it will move and change based on 'today'-- and referencing my start date column. How do I set this up?
Formulas and Functions111
Tiffany Sherrane
Sum of column YTDAccepted Answer

Accepted Answer Jen Tankersley 15 views 3 comments 0 points Most recent by Paul Newcome 03/24/20

First post 03/24/20,Last post 03/24/20
I am not a pro with formulas, but I have been able to figure out most of the formulas I need by perusing this community. However, this formula comes up #unparseable with everything I do. Can someone help me spot what I'm doing wrong? =SU…
Formulas and Functions153
Jen Tankersley
Calculating Fuel ConsumptionAnswered Question

Answered Jacques Hollands 32 views 8 comments 0 points Most recent by Rainier Hollands 03/24/20

First post 03/23/20,Last post 03/24/20
Hi there, I manage a transport fleet and want to use Smartsheet to track the vehicles' fuel consumption. It is calculated by subtracting the kilometres from the previous fill-up from the current fill and dividing this variance by the litre…
Formulas and Functions328
Jacques Hollands
Formula help needed

Rainier Hollands 32 views 4 comments 0 points Most recent by Rainier Hollands 03/24/20

First post 03/24/20,Last post 03/24/20
Hi guys I need help writing a formula. I'm trying to write a formula in which it calculates the fuel consumption for each truck for that specific date. What I was trying to say with the formula is that it should look at which truck, date a…
Formulas and Functions324
Rainier Hollands
Count if by dateAccepted Answer

Accepted Answer Sean Murphy 15 views 5 comments 0 points Most recent by Paul Newcome 03/24/20

First post 03/24/20,Last post 03/24/20
@Paul Newcome Hey Paul, I'm working on further automating the tracking sheet you've helped me with. My goal is to tally a task completion by date from our plant managers progress sheet, currently I'm just counting and manually adding it to…
Formulas and Functions155
Sean Murphy
Adding multiple contacts to a contact field with formulaAnswered Question

Answered cthrasher97141 53 views 5 comments 0 points Most recent by Paul Newcome 03/24/20

First post 01/08/20,Last post 03/24/20
Hello I would like to add multiple contacts to a single contact cell for one task with a formula, is there a away to do this? Can Group Management be utilized? Thank you
Formulas and Functions535
cthrasher97141
ReportingAccepted Answer

Accepted Answer Usha Pillai 15 views 4 comments 0 points Most recent by Paul Newcome 03/24/20

First post 03/23/20,Last post 03/24/20
Hello, I want to have parent row pulled into my report. I used the following formula from one of the previous threads to automatically check parent row if a subtask is due to start in 30 days. However, the formula does not check parent row…
Formulas and Functions154
Usha Pillai
Parent Child NumberingAccepted Answer

Accepted Answer Stavros_McGillicuddy 80 views 11 comments 0 points Most recent by Stavros_McGillicuddy 03/23/20

First post 12/21/19,Last post 03/23/20
With A LOT of help from the community I was able put this together but, I think there must be a better way. The last column is what I am trying to get to. Auto-generated Sequential number in this format T-00001 when Ancestors = 0 Auto-Gen…
Formulas and Functions8011
Stavros_McGillicuddy
Cannot determine the needed formulaAnswered Question

Answered Angela 16 views 1 comment 0 points Most recent by Paul Newcome 03/23/20

First post 03/23/20,Last post 03/23/20
I am needing to get totals for a column based upon a date. I am tracking daily personnel stats (4 different Columns/options) via form submissions. I need a total daily numbers for each column. Can someone help me please. Can this be accomp…
Formulas and Functions161
Angela
Using CountM to return Count on Specific Items?Accepted Answer

Accepted Answer Gaeli 17 views 3 comments 0 points Most recent by Gaeli 03/23/20

First post 03/23/20,Last post 03/23/20
In the CountM Article is states you can collect a total number however I would like a count of Specific Items. For example how many Pears? How many Apples? Is that possible?
Formulas and Functions173
Gaeli
Formula Using IFS, Contains, and ANDAccepted Answer

Accepted Answer Rachel Heard 22 views 5 comments 0 points Most recent by Paul Newcome 03/23/20

First post 03/19/20,Last post 03/23/20
I am trying to troubleshoot the following formula: =IFS((CONTAINS("Shadow", {GI Clinic 3 Session})), AND([Provider Last Name]3), "Scheduled") Logic: If the cross-referenced sheet (GI Clinic 3 Session) contains the word…
Formulas and Functions225
Rachel Heard
Using dates without a date column.Accepted Answer

Accepted Answer Liam Burnett 33 views 12 comments 0 points Most recent by Paul Newcome 03/23/20

First post 03/20/20,Last post 03/23/20
Hi, Is there a way to use dates in formulas without them being in a date column? I am trying to reference a drop-down column that has some dates in it and then take 42 days off of them. Is there a way to do this without the dates being in …
Formulas and Functions3312
Liam Burnett
How do I automate At Risk flag to change to red 72 hours prior to deadline/task end date?Accepted Answer

Accepted Answer April Tucker 21 views 12 comments 0 points Most recent by Paul Newcome 03/23/20

First post 03/20/20,Last post 03/23/20
Hi - I'm trying to automate the At Risk flag to change to RED 72 hours prior to the task deadline so it can trigger an email to the person assigned to the task. I have created the workflow/alert email upon red flag trigger, so that part i…
Formulas and Functions2112
April Tucker
COUNTIFS/CONTAINS FUNCTION

RySols 244 views 15 comments 0 points Most recent by Paul Newcome 03/23/20

First post 12/04/19,Last post 03/23/20
Hi All, I need help with a formula to Count every instance a name appears in a multi-select row of a column based on criteria from another column first. At present this is my first formula: =COUNTIFS({CORP ADMIN TEAM TASKS Range 1}, &qu…
Formulas and Functions24415
RySols
If(And(OrAccepted Answer

Accepted Answer taylor.thompson89836 25 views 29 comments 0 points Most recent by Paul Newcome 03/23/20

First post 03/20/20,Last post 03/23/20
I'm trying to create a formula that includes If, And, and Or in it and I'm having trouble figuring out the correct way to write it. Written out what I need is: If "restrictions in place through" is greater than 3/28/2020 OR equal…
Formulas and Functions2529
taylor.thompson89836

Formulas and Functions

Formulas and Functions

Discussion List