-
Formula to Count Data Broken Down by Month
I am wanting to use a formula to count data in various columns based on specific time period. Example for the month of October, I would like to count various column data and when it rolls into November I would like the formula to continue to work without changing it. I am able to use my formula (see below) to capture…
-
Help with IF formula
Hey Smartsheet Community, I am really not that great with making long formulas, especially with the "IF" formula. Could someone please help me with making a formula for the RYG balls where if the task is less than 50% complete turn red, if the task is between 50%-99% complete, turn yellow and if the task is 100% complete…
-
Limited Availability on drop downs in forms
Hi, relatively new user here - I am wondering if there is a way to make a drop down option limited? Like for appointments or meetings? example: Choose a time slot - but only ones that have not yet been chosen will display? Any help is appreciated!
-
# BLOCKED
Hi, Getting this error in only on one sheet. There are about 20 sheets, but only one throwing the error. Originally, the formula was more complicated, so I tried troubleshooting to see which function is broken. Right now, the only thing in the cell is "=COUNT([Task Name]:[Task Name])" All that is doing is counting all…
-
Formula with multiple IF criteria
Hi all - Trying to create a formula that raises a flag any time a milestone is NOT marked complete AND the due date has past. Below is what I have tried and I am receiving an "Unparseable" error. =IF(Stage2<>"Complete" AND [Due Date]<= TODAY, 1) I am not sure that I am combining the two statesments correctly. Can anyone…
-
Cell Linking Issue
Hi all, I am new to this community but have read numerous feeds posted here and found them really useful. I have now run into a problem of my own that requires some help. I have created a form for our business to complete. The completed lines (Cells) are then linked to another sheet for data collection. The problem here is…
-
Metric Sheet Calculations for a Dashboard
Evening All, i'm looking to see how I can add to this formula a rule to not include sales variances of 100%. This shows when I am comparing year over year sales and the site does not have those figures to compare. =IFERROR(AVG({Sales Variance}), "") Many thanks, Sarah
-
formulas
When I am trying to add several variables using =sum( formula and scroll to locate other variables, my formula is cancelled and I receive an error code. As if I can only use variables/amounts on desktop screen and not above or below.
-
Hi SS Community! Please help if you can...
Help, I'm trying to access an external smartsheet but am unable because I'm logged into Smartsheet with an email address that is different from the one the external ss owner sent to. After my account was originally set up, my IT group had to change my email address but it never got changed in my SS account. Any ideas? :)
-
Favorite a Form
Searched the Help Articles but hadn't seen this question asked. Is there a way to favorite a form, conventionally or unconventionally?
