Welcome to the New Smartsheet Online Community
You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.
Formulas and Functions
Discussion List
-
Auto Fill Fields in SheetAnswered QuestionFirst post 02/25/20,Last post 02/25/20Hello, I have 2 columns I am looking to auto populate based on what is selected in another column. Depending on the requestors name the Manager and Director will populate. The thing I am having trouble with is that multiple requestors ar…Formulas and Functions52Jessica Langston -
Using VALUE within an IF formula to covert text to numberAccepted AnswerFirst post 01/24/20,Last post 02/25/20Hello, I've determined the issue with this formula is that the cell it is pulling from is formatted as text, not a number. I know I need to use the VALUE function to correct this, but I've tried this many different ways and cannot get it t…Formulas and Functions7141Tanya Boehmke
-
Getting #unparseable using multiple IF functionAccepted AnswerFirst post 02/25/20,Last post 02/25/20Hello Smartsheet community, I have been trying to resolve my error by looking online and this forum, but still can't fix my error. I'm hoping you smart experts can help me. I have 2 columns: Completion Status and Status. The Completion Sta…Formulas and Functions114Nathan Nguyen
-
Average FormulasAnswered QuestionFirst post 02/25/20,Last post 02/25/20Hi all, Need help with trying to get a formula for Averaging Transit Days for certain criterias in Carrier and Origin. Ultimately I'm trying to build a dashboard of transit days for each origin location. Below if formula I am trying, but…Formulas and Functions123Apolonio Fama
-
Average duration for a specific type and yearAnswered QuestionFirst post 02/24/20,Last post 02/25/20I'm trying to get a formula to work in the Sheet Summary for a sheet I have that collects data on updates I would like this formula to tell me the Average duration of a specific type of update for a specific year. The columns my formula …Formulas and Functions151Peggy P
-
New Help on If/AND to amortize contract revenueAnswered QuestionFirst post 02/25/20,Last post 02/25/20Below are my cells and formula which keeps returning INVALID: https://us.v-cdn.net/6031209/uploads/005/P93KDRXB6I0I.pngFormulas and Functions81Lisa Burgess
-
How do you write a SUMIFS forumula with 3 criteria?Answered QuestionFirst post 02/25/20,Last post 02/25/20Below is my formula, but I am not getting it right: =SUMIFS({2020 OE Revenue Actual & Projected Range 1}, {2020 OE Revenue Actual & Projected Range 2}, "New Business", [({2020 OE Revenue Actual & Projected Range 3}, …Formulas and Functions121Lisa Burgess
-
Date chaging to start of the week formulaAnswered QuestionFirst post 02/25/20,Last post 02/25/20Hi all, I was wondering if there is a formula that can take my start date that occurs at any random day of the week in column A (lets say tasks starts on a Tuesday 25/02/2020) and give me a date of the start of the week in column B (Mon…Formulas and Functions101Lubica Zummerova
-
Count open RAID items based off of dropdown menuAnswered QuestionFirst post 02/25/20,Last post 02/25/20I'm trying to get a count of open RAID items. We have the following statuses in the status dropdown: New, In Progress, Backlog, Requires Validation, and Complete. What is wrong with this formula?: =COUNTIFS([Type (RAAIDD)]:[Type (RAAIDD)…Formulas and Functions73Allison H
-
RYG Formula Based on CheckboxAccepted AnswerFirst post 02/25/20,Last post 02/25/20Smartsheet Community: I need a little help with this Formula: =IF([email protected] = 1, "Green", IF([email protected] <> 1 "Grey", "Red") I would like to have the row turn Grey if None of the Children Checkbox are Chec…Formulas and Functions95Ray B
-
First post 02/25/20,Last post 02/25/20When I use an automation workflow from a form question hidden as I have the formula as the default value of that question, how can I get it to work it's formula instead of it overriding as a text? So when I put in the formula in the defaul…Formulas and Functions92Shirley Bittner
-
First post 08/20/19,Last post 02/25/20I'm new to smartsheet and trialing it at the moment. I have a question, I hope you can help me with: I have a portfolio of companies in a main sheet and their debt issues, and related stuff in several sheets. Rows are companies/debt issue…Formulas and Functions40910dlnvtl
-
Update cells via form or secondary sheet?Accepted AnswerFirst post 02/19/20,Last post 02/25/20I have a sheet of contracts with 30 columns (status/progression/etc). The columns are updated by different people in different departments. Is there anyway to create a form that would have a dropdown of the contract ID and then the cells I…Formulas and Functions2211Xander Brennan -
Is it possible to use a formula to help users complete a form?Answered QuestionFirst post 01/16/20,Last post 02/25/20We are asking for updates to quality documents. The form asks for the document number and the title. Is there way to auto-populate the title in the Form once the number is entered?Formulas and Functions323Pam Grant -
First post 02/12/20,Last post 02/25/20Hello, I have two sheets. On one I have a column noting the status of a contract, in drop-down style. I would like for when the status is complete on this sheet, for it to check a box on another sheet. Is this possible?Formulas and Functions4311Tanya Boehmke
-
First post 02/25/20,Last post 02/25/20Here is my issue : TASK1 = [Justin], [Celine] | Duration=10days | %Allocation=20% | [*equivalent to 2 worked-days*] TASK2 = [Celine] | Duration=5days | %Allocation=20% | [*equivalent to 1 worked-day*] I am looking to build…Formulas and Functions70Readiness Project
-
Formula for counting values in RedAnswered QuestionFirst post 02/21/20,Last post 02/25/20I have a conditional formatting in a sheet which colors Red if the due date is passed. Now i need a simple formula to populate all the values in Red in a Metric. Any Help?Formulas and Functions196Peter Kafui Doviavu
-
Count If a specific department answered "Yes" at least onceAnswered QuestionFirst post 02/20/20,Last post 02/25/20Good Morning! I've created a conflicts of interest survey and I'm looking for a formula to then reflect on my dashboard for reporting. Can someone please help me identify how i can use a formula to count if someone from a particular depar…Formulas and Functions263Briana Caterino
-
Conditional Linking?Answered QuestionFirst post 02/11/20,Last post 02/25/20Hello, I was wondering if there was a way to unLink cells if a condition is met, i.e. if Column1 is checked then UnLink all cells in all rows this would be to lock values coming in once checked or if that is NOT possible ... If …Formulas and Functions427Jennifer Mahoney
-
Average Formula IssueAnswered QuestionFirst post 02/15/20,Last post 02/25/20Hi there, i am trying to average cells that were built up by formulas. So basically the Column 1-7 are the scores when the task is done , it will turns into 100 when the task is complete, and where the right handside column would need to …Formulas and Functions218Hoi Man Cheung
-
Automation 'Copy to another sheet' doesn't workAnswered QuestionFirst post 02/20/20,Last post 02/25/20I have set up an automation rule to, when triggered, copy rows to another sheet. My trigger is a certain field that changes from 0 to 1. I've tried a couple of times and non of my rows are copied. To test it, I added to the same automatio…Formulas and Functions3811Stelina Todorova
-
Auto Fill Next Day for 1 MonthAnswered QuestionFirst post 02/21/20,Last post 02/25/20Hello, Wanting to be able to enter 1/1/20 & auto fill the rest of the month? Option: I would like to total each week which would need to skip 1 row. If not an option that's fine.Formulas and Functions192Lauren Goedereis
-
First post 02/22/19,Last post 02/25/20Good day all, I've looked around in the community about locking or freezing a current date, but I'm still having issues. My goal is to lock a start date that's triggered by entering a X and have that current date freeze until the x is remo…Formulas and Functions635David Budnick
-
Is there a way to set up Cumulative Roll Up Notification EmailsAnswered QuestionFirst post 02/24/20,Last post 02/25/20We have a large team all working within a workspace, and they already get a TON of email. Is there a way to set up a single daily notification for new items assigned to team members, without it being an email for each sheet? We have abou…Formulas and Functions121Jon Stikka
-
First post 02/20/20,Last post 02/25/20New to SmartSheet and I promise I have been looking around for an answer, but without any luck so I thought I would throw it out to the community... I am looking to sum up all entries in column in a summary total at the top of my sheet, b…Formulas and Functions338Noelle Nordstrom
-
Removing old entries by comparing Modified timeAnswered QuestionFirst post 02/22/20,Last post 02/25/20https://us.v-cdn.net/6031209/uploads/010/S3NB15U77LCD.png Hello, I am trying to find the index number of a matching number in column7. So if Column7 was 56 I would expect that this function =MATCH([Column7]1, (COLLECT([Column7]:[Column7]…Formulas and Functions173Jeffrey Calderon
-
how to count the total of a checkbox field?Answered QuestionFirst post 02/25/20,Last post 02/25/20I need to count the total no. of check marked cells in a columnFormulas and Functions101Megha Natani
-
"Live Date" is 4 weeks from "Submitted Date"Answered QuestionFirst post 02/24/20,Last post 02/24/20Hi, I'd like to set up conditional formatting to let me know if the "Live Date" column on my grid is indeed 4 weeks from the "Submitted Date" (Submitted is an auto-populated cell if that matters.) I know I need a helper…Formulas and Functions111Betsy Herczeg-Konecny
-
Check a task done from a report on a dashboardAccepted AnswerFirst post 02/22/20,Last post 02/24/20It could be I misremembering --- I have a report that lists all the users tasks and the tasks are accompanied by a Done checkbox. Is there a way to allow users to check that box _from the widget on the dashboard_ rather than having to open…Formulas and Functions192Mary_A
-
Help with an existing RYGB FormulaAccepted AnswerFirst post 12/16/19,Last post 02/24/20Below is the current formula in a RYGB column. In the current set up, if the status is "not started" but the End date hasn't past, it will be yellow. Which is fine, however, I would like to update the formula to ALSO take into c…Formulas and Functions6713LLaCosta
