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 Functions21Naveen Srikakulam
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 Functions10kzulpo
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 Functions84productowner
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
Formulas and Functions24Arama Eruera
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 Functions20Camie Keuck
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 Functions13Christine Lazzaro
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 Functions9Gurmeet Mangat
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 Functions8Steven Lagenour
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 Functions16Lexie Ozolnieks
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 Functions20Michael Murphy
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?
Formulas and Functions10Prajna Jain
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 Functions276Alexander Wirtz
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 Functions14Cheryl Lock
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 Functions17Prajna Jain
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 Functions29mmschneider113031
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 Functions22Wini
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 Functions318Joselyn Davila
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 Functions32Lewis Waters
I am trying to ad a specific condition
to an existing formula. However, the existing condition
is interfering with the addition, and I cannot figu…
Formulas and Functions13Marion1972
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 Functions32SoS | Dan Palenchar
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 Functions40Saadia Ashraf
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 Functions51aschneiderheinze74206
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 Functions10KC Fife
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 Functions21Matt Foss
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 Functions38Chris Rea
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 Functions31Megan Cunningham
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 Functions20Dean Ellis
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 Functions18Hani Al Ashkar
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 Functions142Chandler Koury
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 Functions8Admin Account