Formulas and Functions

Formulas and Functions

Discussion List

  • Paul Newcome
    Paul Newcome 772 views 8 comments Most recent by Paul Newcome
    First post 08/02/19,Last post 05/19/20
    I personally am still getting used to the new CONTAINS function, and I have noticed a few others on here looking for clarity. I figured I would start this thread in an effort to hopefully combine knowledge and do some collective brainstorm…
    Formulas and Functions7728
    Paul Newcome
  • Benjo09
    Accepted Answer Benjo09 11 views 3 comments Most recent by Andrée Starå
    First post 05/19/20,Last post 05/19/20
    Hello there, I don't know what happen but my contact list in column 'SPC Contacts' is not carrying over the contact value everytime I have a new row being added at the top of the grid. However, the column 'SPC Manager' is working and carr…
    Formulas and Functions113
    Benjo09
  • Benjo09
    Answered - Pending Review Benjo09 18 views 5 comments Most recent by Andrée Starå
    First post 05/14/20,Last post 05/19/20
    Hi, I have a approval workflow who sends approval request to the managers. But our corporate email sometimes treating it as clutter email and the manager is having difficulty to find the emails from [email protected] And to fix th…
    Formulas and Functions185
    Benjo09
  • Simon Wilcock
    Accepted Answer Simon Wilcock 16 views 4 comments Most recent by Simon Wilcock
    First post 05/09/20,Last post 05/19/20
    Hi I have an approval flow that has multiple approvals. All works well and is effective. I want to start to measure the success rate against each approval stage. For example how many approval request at each stage go through first time or …
    Formulas and Functions164
    Simon Wilcock
  • Julia Mazza
    Accepted Answer Julia Mazza 48 views 2 comments Most recent by Julia Mazza
    First post 05/14/20,Last post 05/18/20
    What replaces/is equal to the "row function"? I am trying to look up data with various criteria and array those multiple matches into separate cells? Using the article and formula below, I tested it in excel with my data and it w…
    Formulas and Functions482
    Julia Mazza
  • James Stump
    Answered - Pending Review James Stump 12 views 1 comment Most recent by [email protected]
    First post 05/18/20,Last post 05/18/20
    I am using a standard sheet with forms, in this sheet i have multiple parent cells. When my guys submit a form it auto adds the information to my main sheet but it populates at the bottom of the sheet. Is there a way to make a new row of i…
    Formulas and Functions121
    James Stump
  • Andre de Oliveira
    Formula assistanceAccepted Answer
    Accepted Answer Andre de Oliveira 17 views 6 comments Most recent by Mike Wilday
    First post 05/18/20,Last post 05/18/20
    I have 3 columns (Health, Status, Due Date) and im struggling to get my formula right to activate the health symbol in my health column. Please assist. The status column is straight forward (In progress, Not Started and Complete). Please c…
    Formulas and Functions176
    Andre de Oliveira
  • Kevin Segrist
    Accepted Answer Kevin Segrist 18 views 5 comments Most recent by Paul Newcome
    First post 05/18/20,Last post 05/18/20
    Hi Everyone, Notes40 contains a manually input numeric value that I'm using in a calculation to populate Notes70. Notes69 is a parent of Notes70, with a manual input of either "NA", "N/A", or no input. The result in t…
    Formulas and Functions185
    Kevin Segrist
  • Bridget Clawson Braaten
    Accepted Answer Bridget Clawson Braaten 19 views 6 comments Most recent by Mike Wilday
    First post 05/15/20,Last post 05/18/20
    Firstly, formulas will be the death of me. My coworker wants to to do this- If the overall plan is 25% complete and 25% through the duration = green If the overall plan is 50% complete and 50% through the duration = green If the overall p…
    Formulas and Functions196
    Bridget Clawson Braaten
  • Suki Teh
    Answered - Pending Review Suki Teh 21 views 1 comment Most recent by Paul Newcome
    First post 05/18/20,Last post 05/18/20
    Hi all, i need help in the following formula. If [Due Date]394) = current month, return value as Current. If [Due Date]394) < current month, return value as Due. If [Due Date]394) = current month, return value as Not Due. =IF(MONTH([Du…
    Formulas and Functions211
    Suki Teh
  • sahilhq
    Month to date formulaAccepted Answer
    Accepted Answer sahilhq 14 views 5 comments Most recent by Genevieve P
    First post 05/17/20,Last post 05/18/20
    Hi, Can anyone please suggest with a "month to date" formula that I can use in my sheet that is set up as shown in the attachment? I have a column that lists down all the dates in the year 2020. I would like to insert the formul…
    Formulas and Functions145
    sahilhq
  • Liam Burnett
    Answered - Pending Review Liam Burnett 183 views 22 comments Most recent by Paul Newcome
    First post 02/27/20,Last post 05/18/20
    Hi, I have a formula on excel that uses WORKDAY.INTL and it doesn't work in Smartsheets. I have made the formula so it only produces dates that are on a Tuesday, Wednesday and a Thursday. Is there another way to do this? Thanks, Liam
    Formulas and Functions18322
    Liam Burnett
  • christy.thompson106676
    christy.thompson106676 293 views 6 comments Most recent by Paul Newcome
    First post 10/07/19,Last post 05/18/20
    Hi - I have a sheet with parent rows and children rows.  Each child row is associated with a status (Not Started, In Progress, and Complete).  For each parent row, I'd like to count the number of child rows that are in each status.   I ne…
    Formulas and Functions2936
    christy.thompson106676
  • Andre de Oliveira
    Accepted Answer Andre de Oliveira 16 views 1 comment Most recent by Genevieve P
    First post 05/17/20,Last post 05/18/20
    We have a worksheet with a number of dates. I would like a formula to automatically calculate a date 6 weeks before a date in anothor cell? Ie. If "FYE Date" is 28.02 or 29.02 then "start date" = "FYE Date" - …
    Formulas and Functions161
    Andre de Oliveira
  • Sidonia Posteuca
    Answered - Pending Review Sidonia Posteuca 20 views 1 comment Most recent by Genevieve P
    First post 05/15/20,Last post 05/18/20
    Hello, I know that Smartsheet does not have an integrated signature collection feature. However, what signature platforms does it work with? More specifically, does Smartsheet collaborate with Collect Signatures Workflow through SharePoin…
    Formulas and Functions201
    Sidonia Posteuca
  • Tony Nguyen
    COUNTIFS functionAccepted Answer
    Accepted Answer Tony Nguyen 18 views 7 comments Most recent by Andrée Starå
    First post 05/14/20,Last post 05/18/20
    Hi All, I have problem with Countifs in Smartsheet during it's still workable in Excell as well. As below picture, I'd like to count product type is "Goalies Mask" with result "FAIL". I applied formula : =COUNTIFS([Pro…
    Formulas and Functions187
    Tony Nguyen
  • Annie Murphy
    Answered - Pending Review Annie Murphy 15 views 1 comment Most recent by Genevieve P
    First post 05/16/20,Last post 05/18/20
    Hi I am new to Smartsheet and really wished I could just run a pivot table against a sales contest my team is running. But we are constantly getting new entries through a smartsheet form and I have created a smartsheet dashboard that upda…
    Formulas and Functions151
    Annie Murphy
  • Jeremy Clark
    Answered - Pending Review Jeremy Clark 16 views 1 comment Most recent by Genevieve P
    First post 05/15/20,Last post 05/17/20
    For work, when we hire people there are variable and fixed benefit rates based on the type of employee they are. I would like to develop a tool much like a smart form where the user inputs hours per week, wage rate, start and end date and …
    Formulas and Functions161
    Jeremy Clark
  • Gary Norton
    Answered - Pending Review Gary Norton 21 views 3 comments Most recent by Andrée Starå
    First post 05/17/20,Last post 05/17/20
    I have a very simple workflow that is not sending email when rows are added. I have been testing with me doing the entry and I don't get emails. My notifications and Automation Permissions are correctly set. Can anyone provide insight or …
    Formulas and Functions213
    Gary Norton
  • Kris Mize
    Accepted Answer Kris Mize 28 views 12 comments Most recent by Genevieve P
    First post 05/12/20,Last post 05/17/20
    I am fairly new to Smartsheet. I am wanting filter data from one sheet to another capturing multiple values in one cell. I have an associate listing with the hardware they are assigned to. They may have several rows with different hardwa…
    Formulas and Functions2812
    Kris Mize
  • Lisa_Doris
    Answered - Pending Review Lisa_Doris 17 views 13 comments Most recent by Andrée Starå
    First post 05/14/20,Last post 05/16/20
    I would like the formula for a simple formula for my flag column. If the "status" is "in progress" and the "due date" is 2 days prior and also after today Thanks in advance
    Formulas and Functions1713
    Lisa_Doris
  • Jona Gjylameti
    Answered - Pending Review Jona Gjylameti 37 views 11 comments Most recent by Andrée Starå
    First post 03/04/20,Last post 05/16/20
    Hello guys, I am trying to add a column that will provide me a %complete for previous week. I have this week's percentage and a PM is updating that weekly however I was wondering if there is a way to have another column that would be upda…
    Formulas and Functions3711
    Jona Gjylameti
  • Roman Pillay
    Survey ScoringQuestion
    Answered - Pending Review Roman Pillay 19 views 3 comments Most recent by Andrée Starå
    First post 04/29/20,Last post 05/16/20
    Hi, I have put together a customer survey with YES and NO response type questions. I need to assign "Yes" with the value "1" and "No" the value "0" for scoring purposes. Not sure as to how to go ab…
    Formulas and Functions193
    Roman Pillay
  • sahilhq
    Answered - Pending Review sahilhq 16 views 5 comments Most recent by Andrée Starå
    First post 05/04/20,Last post 05/16/20
    Hi, Is there a possibility in Smartsheet to somehow link cells that have the same text in the same sheet? For example, I already have a cell in row 89 with the text - "PAC289" and a new row entry with the same text has been inpu…
    Formulas and Functions165
    sahilhq
  • Yashwant Singh
    Answered - Pending Review Yashwant Singh 4 views 3 comments Most recent by Andrée Starå
    First post 04/01/20,Last post 05/16/20
    I am working in workflow design. need condition that send alter notification only if person approved all sheet rows data.. any sheet level approval option are available in smartsheet ?
    Formulas and Functions43
    Yashwant Singh
  • Audrie DeRouen
    Linking sheetsQuestion
    Answered - Pending Review Audrie DeRouen 21 views 3 comments Most recent by Andrée Starå
    First post 05/13/20,Last post 05/16/20
    Hi, I am linking a master sheet to a smaller sheet and I want a formula that will look at the master sheet and add new rows on the smaller sheet if there are some. It will update the linked fields. I am jsut trying to avoid manual work.…
    Formulas and Functions213
    Audrie DeRouen
  • Mike Rini
    Answered - Pending Review Mike Rini 26 views 7 comments Most recent by Andrée Starå
    First post 05/06/20,Last post 05/16/20
    I have an interesting scenario where I am combining 3 SmartSheets into 1, and this happens in three phases: First, someone initiates a request by submitting a request through a form into the first Smart Sheet. When they submit the request,…
    Formulas and Functions267
    Mike Rini
  • Ian Coletti
    Answered - Pending Review Ian Coletti 7 views 5 comments Most recent by Andrée Starå
    First post 05/14/20,Last post 05/16/20
    I'm trying to count check boxes if the % complete is <100. I can COUNTIF the check boxes on their own, but when I add the % complete reference, I get the incorrect argument set error. Any ideas? Here's the formula: =COUNTIF({Portfolio_R…
    Formulas and Functions75
    Ian Coletti
  • Jen Evans
    Contains FormulaAccepted Answer
    Accepted Answer Jen Evans 22 views 2 comments Most recent by Jen Evans
    First post 05/15/20,Last post 05/16/20
    I currently have a formula that looks to see if a specific phrase is contained within a range of cells: =IF(CONTAINS("Apple", Fruit1:Test1), "Fruit") Is there a way to have the formula look for another phrase as well? …
    Formulas and Functions222
    Jen Evans
  • Daniel Montoya
    Answered - Pending Review Daniel Montoya 21 views 3 comments Most recent by [email protected]
    First post 05/15/20,Last post 05/15/20
    I can't seem to figure out how to get this formula to count only the children rows that have a certain status. For example: I want to get a count of the status of Green, Yellow, and Red of only the children rows of Parent row SWAR Carib…
    Formulas and Functions213
    Daniel Montoya