-
How to find 2 values from a multi-select column for reporting
I am trying to count how many times in a smartsheet 2 values show up in a multi-select column. example: i have a multi-select column with multiple options and I want to count how many times "Drainage" and "Roadway" are both selected. This can be done with the filter in the grid using the "has all of" options. This is the…
-
Formula to Change Harvey Ball Color Based off of a Word
I've seen so many examples of "Nesting IF" formulas for changing a Harvey Ball to a different color based off of multiple numeric or date scenarios. What I haven't come across is a way to change the ball color based off of verbiage: Example: I change a cell to Rejected and the ball turns Red. I change the same cell to…
-
How do I get my excel formulas to work in smartsheet. I am getting #blocked & #unparseable
-
Invalid Operation with Countifs formula
Hi, The formula =COUNTIFS({CR Requests Inventory Request Monday}, [Monday of the week]@row, {CR Requests Inventory Status}, NOT("5) On Hold")) returns an Invalid Operation error. I checked the column properties and the references, all look good. The same formula works referencing another sheet. =COUNTIFS({CR Archived…
-
Average Days to complete within a date range
I would kindly like to ask for some assistance. I am trying to get the average number of "Days to Complete" if the "Resolved Date" is within March. I've tried the formula below but I am getting an #UNPARSABLE error. =AVG(COLLECT({2021 Archive Days to Complete Range},[Days to Complete]:[Days to Complete], {2021 Archive…
-
Is there a way to limit the max number of characters in a text/number field?
I have a form that I want to use to capture telephone info. Is there a way to limit the max number of characters that can be input in a cell and perhaps show an error message to the user? Also, is there a way to limit input to numerical text only? Thanks. Bill
-
Help with Formula for Budget Spread
Can someone help with creating a formula? We are trying to develop a formula to help create an automatic budget spread/phasing over the year. Sheet Info: We have columns named for the twelve months of the year We have a BUDGET column We have a START DATE column We would like to build a formula that would take a $100,000…
-
CountIf formula using Sheet Reference
Im trying to do a CountIF conditional formula using to columns in a referenced sheet. I"m trying to only count the open Risks. So Status1 is Type (Risk, Issue) Status2 is Status (Open, Closed) This is what I have so far, but it's not taking. Any suggestions? =COUNTIF(AND{PingOne Verify: Risk, Issues, & De... Range…
-
Symbols don't appear anymore when used in a Formula
Hi, please help me ! Symbols don't appear anymore in columns where there is a formula. It only shows the word ("Empty", "Red", etc). Everything was normal. Then I changed the name of a column and it stopped working ! I tried to create new columns, or to use different symbols, even to make a copy of the sheet under a new…
-
Error on copying a formula from one row to the next row
I am using the Survey Intake - Employee Pulse Check template package to create an NPS survey sheet, report and dashboard. I've updated my questions on the template sheet and I am now editing the "helper columns" to reflect the changed questions. I created a formula to count my responses on the first row, but when I try to…