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
-
Determining Resource Allocation for Resource ViewIn Formulas and FunctionsHello! I am trying to find a way to determine resource allocation in project plans so that they more accurately reflect the availability of my team in the resource view. We have individual project plans for each project, which all fe…
-
VLookup Range Changing - UPDATED - RESOLVEDIn Formulas and FunctionsI have a sheet of VLookups which I get to be working perfectly then when I come back later (sometimes as little as 10-15 minutes) most cells have been changed to "No Match". To fix this I simply have to re-input the range to what…
-
Automating RYG Status Balls Based Off Two Date ColumnsIn Formulas and FunctionsI have two columns "Actual Start Date" and "Actual End Date", I want to have a formula for the status column using the RYG Status balls that will: - Red when nothing is in either of the two cells - Yellow when there i…
-
COUNTIF Formula QuestionIn Formulas and FunctionsI'm trying to determine a COUNTIF formula to show what deliverables are due in the next 7 day period based upon a Due Date column. However, I'd like said formula to only showcase what deliverables are in the next 7 days and ALSO be able to…
-
Checkbox FormulaIn Formulas and FunctionsHi there, I have created a document designed to check off whether or not we have received scores back from our partners using a column of check boxes. I need to input a formula that counts the boxes that have been checked off versus the to…
-
Semicolons in German language settingsIn Formulas and FunctionsHi community, I had a hard time with Smartsheet support (used to be different) regarding my issue. Has anyone else with Smartsheet set to german speaking setup the problem described below? Starting some time last week, Smartsheet starte…
-
Formula to have status "ball" change color for blank cellIn Formulas and FunctionsI would like to have the status "ball" color change to red if the column cell is blank and green if the column cell has a date entered in it. PLEASE HELP!!!!!!
-
Defining a range using a variable as the row #In Formulas and FunctionsHi, Newbie question here. Let's say we have a simple SUM formula: =SUM([Column1]15:[Column4]15) Is there a way to specify the row # using a variable or some kind of reference to a number value in a cell? For example, rather than "…
-
Formulas and Referencing SheetsIn Formulas and FunctionsSo with the new referencing sheets feature (at least I think it's new) is it possible to have one sheet that would be the master for all summaries and metric information rather than roll them up into extra rows at the top of each sheet?
-
Daily NotificationIn Formulas and FunctionsHi All, Is there a way to send a daily notification when a task is not complete? The way my sheet is set up is the RYG dots are automated depending on the due date, and based on those dots, notifications get sent (Yellow is the due date,…
