Formulas and Functions

Help needed with averaging RYGB balls of children cellsAccepted Answer

Accepted Answer Naveen Srikakulam 21 views 2 comments 0 points Most recent by Naveen Srikakulam 07/07/20

First post 07/05/20,Last post 07/07/20
Hi, I wanted to know how I can average the RYGB balls of the children cells. Something on the lines of if there is even 1 red, then turn the parent red. If there are no reds and at least one yellow then turn the parent yellow. If there are…
Formulas and Functions212
Naveen Srikakulam
Auto-populate Cell after triggerQuestion

Answered - Pending Review kzulpo 10 views 3 comments 0 points Most recent by Andrée Starå 07/07/20

First post 07/07/20,Last post 07/07/20
Hi Everyone, I am trying to auto-populate a cell with a date based on status "Sent to Client" (dropdown) being selected. I have this functionality already working with the formula: =(IF([email protected] = "Sent to Client", …
Formulas and Functions103
kzulpo
How to Calculate Standard Deviation in a smartsheet?

productowner 84 views 5 comments 0 points Most recent by [email protected] 07/07/20

First post 04/04/19,Last post 07/07/20
Hi, I'm working on getting all metrics for a large project into a dashboard in smartsheets. I've been tracking a burn up chart in google sheets, but think that connecting directly to it doesn't look clean. So in an attempt to copy it over,…
Formulas and Functions845
productowner
How do I use IF formula to change a colour based on a percentage column?Question

Answered - Pending Review Arama Eruera 24 views 20 comments 0 points Most recent by Paul Newcome 07/07/20

First post 05/07/20,Last post 07/07/20
I have a status column with red, yellow and green. I'm needing a formula to change these colours when the percentage complete column gets below a certain percentage. i.e. 1-50% Red 51%-99% Yellow 100% Green
Formulas and Functions2420
Arama Eruera
Vacation Tracker - formula between datesAccepted Answer

Accepted Answer Camie Keuck 20 views 2 comments 0 points Most recent by Camie Keuck 07/07/20

First post 07/02/20,Last post 07/07/20
Hi All I have a formula question - I am looking for the number of vacation days to populate when an anniversary date is between a certain date range. For instance with an anniversary date of 03/05/1997, if dates are between 03/05/1997 and …
Formulas and Functions202
Camie Keuck
Conditional formatting based on comparison between two datesQuestion

Answered - Pending Review Christine Lazzaro 13 views 2 comments 0 points Most recent by Paul Newcome 07/07/20

First post 07/07/20,Last post 07/07/20
Good Day, In my project. I have a Date Due column and a Planned completion date column. I would like the Planned Completion Date to turn red if it is after the Date Due, is this possible?
Formulas and Functions132
Christine Lazzaro
Converting 2020-05-20T12:38:08.063 to a date formatQuestion

Answered - Pending Review Gurmeet Mangat 9 views 1 comment 0 points Most recent by Paul Newcome 07/07/20

First post 07/07/20,Last post 07/07/20
Hi Everyone, I am using data uploader and importing an excel file that uses this date/time format 2020-05-20T12:38:08.063. Looking for suggestions on how to extract the date efficiently. At the point of export into excel there is no optio…
Formulas and Functions91
Gurmeet Mangat
Round Robin/Cue Function?Question

Answered - Pending Review Steven Lagenour 8 views 1 comment 0 points Most recent by Paul Newcome 07/07/20

First post 07/07/20,Last post 07/07/20
Hello, I'm looking to incorporate a simple round robin feature, i.e.: Column Header Titles: C1) Unique ID C2)A C3)B C4)C Step 1) Person S uses simple form that only requires Person S to enter a unique ID - the person enters that and saves…
Formulas and Functions81
Steven Lagenour
Auto fill information in sheet when a check box is checked in a different sheet?Accepted Answer

Accepted Answer Lexie Ozolnieks 16 views 7 comments 0 points Most recent by Paul Newcome 07/07/20

First post 07/07/20,Last post 07/07/20
Hi! I am trying to figure out how to auto fill information into my sheet, when I check a box in a different sheet. Essentially, all I want to do is autofill the check box on sheet 2 once it is checked on sheet 1. Is this possible?
Formulas and Functions167
Lexie Ozolnieks
Auto-Number Using Parent() and Child() RelationshipAccepted Answer

Accepted Answer Michael Murphy 20 views 2 comments 0 points Most recent by Michael Murphy 07/07/20

First post 07/04/20,Last post 07/07/20
I have a sheet our team uses to track tasks/issues that need resolution as we move through project execution. Initially, I set the sheet up with a column to auto-number every new task/issue entry. This way the task/issue can easily be refe…
Formulas and Functions202
Michael Murphy
Formula to join text strings from 10 columnsQuestion

Answered - Pending Review Prajna Jain 10 views 1 comment 0 points Most recent by Paul Newcome 07/07/20

First post 07/07/20,Last post 07/07/20
I tried Join Function to add text strings from 10 different column using following but no success: =JOIN([Region 1]:[Region 1], [Region 2]:[Region 2],[Region 3]:[Region 3],””) Can anyone help please? Thanks Prajna
Formulas and Functions101
Prajna Jain
Notify an assignee that the predecessor has complete his task.

Alexander Wirtz 276 views 6 comments 3 points Most recent by Tori Isbell 07/07/20

First post 03/26/19,Last post 07/07/20
I want to use smartsheet as an international project management tool. One thing is driving me creasy. I want to send out a notification to an assignee if the predecessor task is completed. Please find attached a screenshot of my scenario.…
Formulas and Functions2766
Alexander Wirtz
Populate a text value based on a date rangeAccepted Answer

Accepted Answer Cheryl Lock 14 views 3 comments 0 points Most recent by Paul Newcome 07/07/20

First post 07/06/20,Last post 07/07/20
Hi All, I'm fairly new to Smartsheet and I'm trying to set a text value based on a date range. Reading through all the responses it seems possible but a little messy. All I'm trying to do is automatically populate a Quarter value based on …
Formulas and Functions143
Cheryl Lock
Formula to check the cell for 4-5 text stringsAccepted Answer

Accepted Answer Prajna Jain 17 views 15 comments 0 points Most recent by Stefan 07/07/20

First post 07/06/20,Last post 07/07/20
I have a condition where in the formula should check the text in CELL A and return value based on the assigned values and should leave the formula cell BLANK if none of the condition is satisfied. I tried it through spreadsheet and the for…
Formulas and Functions1715
Prajna Jain
COUNTIF using multiple criteriaAccepted Answer

Accepted Answer mmschneider113031 29 views 2 comments 0 points Most recent by mmschneider113031 07/07/20

First post 07/01/20,Last post 07/07/20
I am trying (what I thought was a simple formula) to countif using multiple criteria. I have a drop-down column. I want to calculate the number of "yes" and number of "Maybe - Depending on caseload" for the CHILDREN. …
Formulas and Functions292
mmschneider113031
Automatically adding a new row when a new phrase/word is added to a colomnQuestion

Answered - Pending Review Wini 22 views 5 comments 0 points Most recent by Andrée Starå 07/07/20

First post 07/03/20,Last post 07/07/20
I don't know if this is possible at all. So I have a column and it's the importance of the tasks in the sheet. I have another sheet that has a summary and tally up how many tasks are there for each severity level. Someone did this manually…
Formulas and Functions225
Wini
Dashboard Viewer FilterAccepted Answer

Accepted Answer Joselyn Davila 318 views 5 comments 0 points Most recent by Gary Van Rensburg 07/07/20

First post 01/13/20,Last post 07/07/20
I attended Engage last year and a new advanced option was announced called "Dashboard Viewer." I can not find this on any of my dashboards. Is there anyway I can filter the data on by dashboard by different users viewing it? …
Formulas and Functions3185
Joselyn Davila
Bulk adding users to groupQuestion

Answered - Pending Review Lewis Waters 32 views 5 comments 0 points Most recent by Stefan 07/06/20

First post 07/02/20,Last post 07/06/20
Hi, I am trying to add a bulk of emails into a smartsheet group. It is suggested that you can do this by pasting email multiple email addresses into the " add members" fiels; however it just returns " please enter a valid em…
Formulas and Functions325
Lewis Waters
Add a specific condition to an existing formulaQuestion

Answered - Pending Review Marion1972 13 views 8 comments 0 points Most recent by Marion1972 07/06/20

First post 07/06/20,Last post 07/06/20
Hi, I am trying to ad a specific condition IF(TD<[@[DUE DATE]]+7,"PIPELINE" to an existing formula. However, the existing condition IF(TD<[@[DUE DATE]],"CURRENT" is interfering with the addition, and I cannot figu…
Formulas and Functions138
Marion1972
Use Zapier to populate a column based on the date a comment was addedAccepted Answer

Accepted Answer SoS | Dan Palenchar 32 views 2 comments 0 points Most recent by SoS | Dan Palenchar 07/06/20

First post 06/22/20,Last post 07/06/20
Hi everyone, I am trying to use Zapier to add the date to a row that reflects when a comment was last added in that row. I thought I got it up and working, but ran into an error when I moved from testing to implementation. I used the "…
Formulas and Functions322
SoS | Dan Palenchar
Formula for counting values from single-select drop down on a formAccepted Answer

Accepted Answer Saadia Ashraf 40 views 34 comments 0 points Most recent by Saadia Ashraf 07/06/20

First post 06/16/20,Last post 07/06/20
Hello, I'm trying to figure out how i can count or which formula i can use to count how many people selected their desired choices from three different categories (single-select dropdown) that falls under 3 different groups. I created a fo…
Formulas and Functions4034
Saadia Ashraf
Counting Instances Across SheetsAccepted Answer

Accepted Answer aschneiderheinze74206 51 views 35 comments 0 points Most recent by Paul Newcome 07/06/20

First post 06/20/20,Last post 07/06/20
I am building a dashboard for each of the colleges at my university. I originally created a Smartsheet for each college that lists all of the courses in each of the programs in the college, documenting whether or not we have a course maste…
Formulas and Functions5135
aschneiderheinze74206
Countif coming over as percentageAccepted Answer

Accepted Answer KC Fife 10 views 2 comments 0 points Most recent by KC Fife 07/06/20

First post 07/06/20,Last post 07/06/20
Hello, for some reason I have one formula using a cross sheet reference that comes over as a percentage when the rest come over as values which is what I want. (Image) (Image) (Image) I really don't understand why the "complete"…
Formulas and Functions102
KC Fife
How would I return a specific status based on differences in multiple other cell columns?Accepted Answer

Accepted Answer Matt Foss 21 views 4 comments 0 points Most recent by Matt Foss 07/06/20

First post 07/02/20,Last post 07/06/20
I am attempting to create an automatic status update that is driven by different options selected in multiple other cell columns. For example: I want my Status column to indicate "Assessment" if another column regarding the asses…
Formulas and Functions214
Matt Foss
referencing using @rowQuestion

Answered - Pending Review Chris Rea 38 views 16 comments 0 points Most recent by Paul Newcome 07/06/20

First post 06/08/20,Last post 07/06/20
I've tried multiple searches and haven't found the right keyword/tricky phrase to answer my question. I am using a form for submissions and trying to calculate how long a trend has been occurring. Right now my working formula is this: =…
Formulas and Functions3816
Chris Rea
Count Projects happening within the same monthAccepted Answer

Accepted Answer Megan Cunningham 31 views 2 comments 0 points Most recent by Megan Cunningham 07/06/20

First post 07/02/20,Last post 07/06/20
Hello! I am trying to count projects by person overtime (monthly) in order to show how many projects a person on my team has going on simultaneously. I am using two date columns- Kick off date (KO) and implementation date (Imp Date) with …
Formulas and Functions312
Megan Cunningham
Using Smartsheet offlineQuestion

Answered - Pending Review Dean Ellis 20 views 2 comments 0 points Most recent by Dean Ellis 07/06/20

First post 06/25/20,Last post 07/06/20
Hi, I've been developing a number of sheets for an organisation. Id like to know if there is a feature where The Mobile app can use smart sheet offline in the field where there may be no access to the internet and then uploading the change…
Formulas and Functions202
Dean Ellis
Importing equation from ExcelAccepted Answer

Accepted Answer Hani Al Ashkar 18 views 3 comments 0 points Most recent by Genevieve P 07/06/20

First post 07/02/20,Last post 07/06/20
I imported a sheet with the below equation from Excel. However,it comes back with #UNPARSEABLE and i'm not sure where it's going wrong on Smartsheet, any help or advice would be highly appreciated. =COUNTIFS([Visit Interval]1:[Visit Inter…
Formulas and Functions183
Hani Al Ashkar
SUMIFS + CONTAINS Formula help.Question

Answered - Pending Review Chandler Koury 142 views 6 comments 0 points Most recent by Genevieve P 07/06/20

First post 01/29/20,Last post 07/06/20
Hi there! I am trying to figure out how many projects start in the current month for a designated department. This formula works: =COUNTIFS(Department:Department, "Marketing", Start:Start, IFERROR(MONTH(@cell), 0) = MONTH(TODA…
Formulas and Functions1426
Chandler Koury
Indicating status of Children cellsAccepted Answer

Accepted Answer Admin Account 8 views 3 comments 0 points Most recent by Genevieve P 07/06/20

First post 07/04/20,Last post 07/06/20
Hello - we have a sheet with Health symbols for the Tasks which are children under Phases of a project. I'd like to be able to indicate on the parent cells of the Health column if there is a non-green symbol among their Children cells in …
Formulas and Functions83
Admin Account

Formulas and Functions

Formulas and Functions

Discussion List