Formulas and Functions
Stumped by a formula? Ask for help or find examples to see how others use a formula to solve a similar problem.
Discussion List
-
Formula Help pleaseIn Formulas and Functionsi have a column titled # Wins and wound up with a percentage towards my Wins goal. That said i want to use RYG lights based on how close i am to the goal. So here's what i wrote but i know i'm missing something. Any help would be much appr…
-
Autofill a column based on another column valueIn Formulas and FunctionsI have one column set up with a dropdown menu and want another column to autofill with a specific value tied to each dropdown menu selection. Is this possible?
-
Match Two Entries from Two Separate Form Sheets, Assign StatusIn Formulas and FunctionsI have an "Assignment" form that creates a system generated number. The crew foreman will use this form for their assignment, then they will populate a "Production" form using the system generated number from the "…
-
return list from another sheetIn Formulas and FunctionsAnyone able to offer some help on the formula below - trying to return a list of information relative to an employee ID number to a column. There will be several matches per ID, e.g. Matt worked item 1.. 2... 3.. and 7. I want to retur…
-
Summing of colored "conditional" cellsIn Formulas and FunctionsHello All, I am trying to count or sum how many colored cells there are within a row. The rows consist of test questions and are set to turn red if the condition is not met (answer is incorrect). Is there a way to sum all of the condition…
-
Nested IF Then And StatmentIn Formulas and FunctionsI am trying to finalize a Nested If Then /And Statement. In one of my logical functions, I am trying move to the next condition if a cell has a date input into. When I try to use the logic if cell > 0, it returns an error. What would…
-
cell reference based on dateIn Formulas and FunctionsWe have a yearly schedule for all our field guys that is updated a week prior and sent out to the field so everyone knows where they will be working for the upcoming week. My question is can I tie a roll up sheet to the master schedule sh…
-
Help on formula: countifs with multiple criteriaIn Formulas and FunctionsHi everyone, I need help on the below formula. I am trying to get the number of active projects based on the columns Section and Stage (see attached image). The 2 sections are called Food and Non-Food. The active stages are called Plann…
-
Date changes to tomorrow after 5pmIn Formulas and FunctionsHello, I have been trying to find a work around for an issue I am having on sheet we use. We are currently using a sheet for employees to submit when they check out and check in equipment via a form. We were using the auto created date…
-
Multiple Countifs and Children to use in a DashboardIn Formulas and FunctionsHello Everyone! I'm new to figuring out counts in SmartSheets and Dashboads/Sights and could use a little help. I have a sheet that is connected to Salesforce via the Salesforce Connector, so the data is dynamic. I currently have the sh…
