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 Novembe…
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…
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 bee…
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 …
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(…
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…
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 figure…
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 deskt…
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 …